Unix Technical Forum

Fragmenting Indexes

This is a discussion on Fragmenting Indexes within the Informix forums, part of the Database Server Software category; --> Version: IDS 10 I am currently looking at various fragmentation strategies for Indexes that have keys of type CHAR. ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 05:17 PM
mohitanchlia@gmail.com
 
Posts: n/a
Default Fragmenting Indexes

Version: IDS 10

I am currently looking at various fragmentation strategies for Indexes
that have keys of type CHAR. I have following questions:

1. Columns that have value of "000987" but is a CHAR, which strategy
makes more sense, doing the fragmentation by using SUBSTR or using MOD
of HASH. Is there any such HASH function in IDS that could be used for
such scenarios. Is there any other fragmentation strategy that is
better than above.

2. Column that are CHAR and are typically string, what would be a
better fragmentation strategy. What options do I have other than
SUBSTR.

3. Is substr efficient ? Does it slow down building indexes

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:22 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com