Index rebuild issue [message #303181] |
Thu, 28 February 2008 04:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
tannad
Messages: 43 Registered: January 2008 Location: mumbai
|
Member |
|
|
Hi all;
My database is OLTP having thousands of tables
there are so many indexes on the table
For tuning issue
How I find that which specific indexes have to rebuilt or coalesces?
Thanks in Advance
Tannad
|
|
|
|
|
Re: Index rebuild issue [message #303188 is a reply to message #303185] |
Thu, 28 February 2008 04:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
tannad
Messages: 43 Registered: January 2008 Location: mumbai
|
Member |
|
|
No
I want just the information that
at what time we have to rebuilt the index and which index should be rebuild?
thanks for reply
|
|
|
|