how to analysis trace table data before and after table rebuild index
i have 4 tables with data before rebuild index and after rebuid index of 2 table each.
i named tables as bad1, bad2, good1 and good2.
obviously the performance increased after rebuild index with dbreindex
how can i know what is eaxtly happened after rebiulding index
how i can analysis data to know the reasons
i am using standard edition 2005