Apr 17, 2011 #1 TimPen Technical User Mar 28, 2011 41 ZA I am looking for guidelines / recommendations / suggestions about which fields in a database to index. Is it poor design to index too many fields?
I am looking for guidelines / recommendations / suggestions about which fields in a database to index. Is it poor design to index too many fields?
Apr 17, 2011 1 #2 TheAceMan1 Programmer Sep 23, 2003 11,174 US How are ya TimPen . . . There's plenty of info if you perform a web search. See the basic Idea: Create and use an index to improve performance See Ya! . . . . . . Be sure to see faq219-2884 [blue]Worthy Reading![/blue] Also faq181-2886 [blue]Worthy Reading![/blue] Upvote 0 Downvote
How are ya TimPen . . . There's plenty of info if you perform a web search. See the basic Idea: Create and use an index to improve performance See Ya! . . . . . . Be sure to see faq219-2884 [blue]Worthy Reading![/blue] Also faq181-2886 [blue]Worthy Reading![/blue]