bde_rebuild.sql
1) Check Metalink Note:182699.1
2) Rebuild or Coalesce?
3) Compare costs
4) Taking an export of the owning schema or database, specifying ROWS=NO so that data within the database is not exported, and then using the import with the option INDEXFILE will produce a file listing all of the commands to build the indexes.
PS: You can use the "COMPUTE STATISTICS" option on the CREATE or ALTER INDEX commands.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Reply With Quote