| Rebuilding Indexes [message #331009] |
Wed, 02 July 2008 02:39  |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
Hi to all,
I have a doubt regarding index rebuilding.
I have analyzed one index with this
ANALYZE INDEX SR_INDEX_AK4 VALIDATE STRUCTURE.
When i queried Index_Stats Table i got the following result.
select height,name,lf_rows,del_lf_rows,(del_lf_rows/lf_rows)*100 "Percentage" from index_Stats;
HEIGHT NAME LF_ROWS DEL_LF_ROWS Percentage
4 SR_INDEX_AK4 61854857 5033 .00813679
After that i have rebuild the index using the command
ALTER INDEX ST_INDEX_AK4 REBUILD ONLINE;
After this command i again validated the index and used index_Stats to get the results
The result i got is,
HEIGHT NAME LF_ROWS DEL_LF_ROWS Percentage
4 SR_INDEX_AK4 61849824 0 0
Deleted rows has been removed but the height column remains 4.
What does it signifies.
I have read from the article if the height value is greater than 3 we have rebuild the indexes.
Can any one give me a clear idea about this.
Thanks in Advance,
Seenu
|
|
|
|
|
|
| Re: Rebuilding Indexes [message #331033 is a reply to message #331009] |
Wed, 02 July 2008 03:32  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
| Quote: | I have read from the article
|
You have read from what article? Can you post a link to it? Maybe you have mis-read, or read the statement out of context (but more than likely, as Michel says, the article is just plain wrong)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Rebuilding Indexes [message #331245 is a reply to message #331009] |
Wed, 02 July 2008 14:33 |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
Actually i have a doubt regarding the indexes but its not related to peformance.
My other doubt is,
Our database performance is very slow. What are the steps i have to do, to check and change the database performance faster than now.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
