dbTalk Databases Forums  

Index space reuse

Go Back dbTalk Databases Forums Databases comp.databases.informix Index space reuse

comp.databases.informix comp.databases.informix


Discuss Index space reuse in the comp.databases.informix forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Gilbert, Dale
 
Posts: n/a

Default Index space reuse - 10-18-2007 , 11:23 AM





Does 7.31 reuse index slots after rows are deleted?



Thanks



Dale R. Gilbert
NCG Informix Database Engineering
Bank of America
dale.gilbert (AT) bankofamerica (DOT) com <mailto:dale.gilber (AT) bankofamerica (DOT) com>
Phone: (302) 457-4186
Cell: (858) 449-7459





Reply With Quote
  #2  
Old   
Art S. Kagel
 
Posts: n/a

Default Re: Index space reuse - 10-18-2007 , 03:10 PM





On Oct 18, 11:23 am, "Gilbert, Dale" <dale.gilb... (AT) bankofamerica (DOT) com>
wrote:
Quote:
Does 7.31 reuse index slots after rows are deleted?

Thanks

Dale R. Gilbert
NCG Informix Database Engineering
Bank of America
dale.gilb... (AT) bankofamerica (DOT) com <mailto:dale.gil... (AT) bankofamerica (DOT) com
Phone: (302) 457-4186
Cell: (858) 449-7459
Yes. Also empty nodes are compressed by the BTree cleaner threads
in the background.

Art S. Kagel



Reply With Quote
  #3  
Old   
Art S. Kagel
 
Posts: n/a

Default Re: Index space reuse - 10-19-2007 , 01:00 AM


On Oct 18, 11:23 am, "Gilbert, Dale" <dale.gilb... (AT) bankofamerica (DOT) com>
wrote:
Quote:
Does 7.31 reuse index slots after rows are deleted?

Thanks

Dale R. Gilbert
NCG Informix Database Engineering
Bank of America
dale.gilb... (AT) bankofamerica (DOT) com <mailto:dale.gil... (AT) bankofamerica (DOT) com
Phone: (302) 457-4186
Cell: (858) 449-7459
Yes. Also empty and mostly empty index nodes are compressed by the
btree cleaner threads in the background.

Art S. Kagel



Reply With Quote
  #4  
Old   
Art S. Kagel
 
Posts: n/a

Default Re: Index space reuse - 10-19-2007 , 01:05 AM


On Oct 18, 11:23 am, "Gilbert, Dale" <dale.gilb... (AT) bankofamerica (DOT) com>
wrote:
Quote:
Does 7.31 reuse index slots after rows are deleted?

Thanks

Dale R. Gilbert
NCG Informix Database Engineering
Bank of America
dale.gilb... (AT) bankofamerica (DOT) com <mailto:dale.gil... (AT) bankofamerica (DOT) com
Phone: (302) 457-4186
Cell: (858) 449-7459
Yes. Also empty and mostly empty index nodes are compressed by the
btree cleaner threads in the background.

Art S. Kagel



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top