I've heard people refer to 'natural order' of tables, and I'm unclear as to what it means. My boss seems to think that it refers to the order that data is most frequently accessed. Because of this, he plans on writing a program that copies the records from our frequently-traversed tables into the order that they are most frequently traversed (by policy number). He suspects that this will improve seek time of the read/write heads of the server. I'm skeptical that this will make any difference, so I figured I'd investigate but was unable to find anything conclusive. So now I turn to you all! :)
Thanks in advance.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement