Hi all,
I have an index whose height level is high every week and I have rebuilt twice and the del count is 0 I plan to rebuild again.
Any thought on what this or permanent solution?.
Thanks.
YB.
Printable View
Hi all,
I have an index whose height level is high every week and I have rebuilt twice and the del count is 0 I plan to rebuild again.
Any thought on what this or permanent solution?.
Thanks.
YB.
Looks like your table has lot of Delete issued against it, and it makes height to grow as the new inserts span new blocks.
Do you really need index on this table?