Tadeu,
I don't think it's a matter of what the system allows, but what is best practices. There is no single right answer. You have to consider how many records are in the table, what the most common searches will be, etc. It's something that you need to work with a DBA on. They can run SQL Profiler and other tools to be able to determine what is causing the most slowdowns in the queries. Then, when you look at that and see the need for a new index, you can create a new one. Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Wednesday, May 14, 2008 12:36 PM To: arslist@ARSLIST.ORG 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___ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
