Tadeu, Indexesare a balencing act. the more you have the more options the sql analyzer has to construct an optimal execution plan. The cost is at the write, meaning commit, time. the system has to update all the indexes to maintain system integrity. This cost time during the commit phase. If your data is infrequently written or change, more indexes are ok. If the data is volital or not highly selective, more indexes are bad. the answer is it depends on your data. John
----- Original Message ---- From: Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, May 14, 2008 1:35:46 PM Subject: Max Index on Form! ** Hi all, I'd like to know if has a white paper that describes what's max number of index to a form... I've read a document from 2003 and I've noticed that more than 7 index (or 4 composite index) in one form is bad... I have an application that has a form with 8 index (some of them composite index) ... and we're having problems with performance (searches in database).. I'd like to know if it's possible to insert more index in this form! Remembering: I'd like to improve performance... Att, Tadeu Augusto Dutra Pinto__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
