G
gus
Guest
George is right. However, there is more to the story. If you choose a dump index with the goal of minimising dump time, this will also establish the order in which the records are loaded. this means that theordering imposed by the index you used for the dump will match the phyiscal storage order. That index will therfore have the highest cluster ratio and an index or table scan using that index will require fewer disk reads and (often more importantly) fewer disk seeks than using another index. This may not be desireable if the application is doing a high percentage of its queries via another index - performance will be higher (possibly a /lot higher/ ) if you dump each table by an index preferred by the application.
Continue reading...
Continue reading...