| ramesh |
Posted: Dec 24, 2007 08:56:52 AM |
Total Post: 69
Joined: Dec, 2006
|
Hi..
can anyone send me the script to find the TOP index's used
and find the indexes to the rebuild again.
or suggest me on which site i will get it.
on ramesh.vidap@sunpharma.com
..ramesh |
|
|
Mohammed Taj |
| Posted: Dec 25, 2007 12:05:35 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
about index monitoring.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/indexes.htm#sthref2563
about index rebuild.
Actually index rebuild is myth for performance.
but in below condition you have to rebuild index.
1. when table move from tablespace to tablespace
2. when index is fragmented.
3. when index status is invalid.
|
|
|
|
|
positive |
| Posted: Jun 27, 2008 06:11:06 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
Run ANALYZE statistics on the index, rebuild index from the results
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |