StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Field index required for Dialog Browser

Field index required for Dialog Browser

Edhy Rijo — Thu, 25 Sep 2008 10:13:56 GMT

What is the rule for the need of indexes on fields used in a Dialog Browser?

I have a Dialog Browser with 10 fields (see attached picture) and I am wonder if I should have an index on these 10 fields?

Thanks!

RE: Field index required for Dialog Browser

Edhy Rijo — Thu, 25 Sep 2008 10:13:56 GMT

Thanks for the clarification.

Back in VFP it was recommended to have an index in every column used in the where condition to make use of the Rushmore technology in VFP, now in MS-SQL, it is more of monitoring the application performance before start adding indexes all over :P.

RE: Field index required for Dialog Browser

Trent L. Taylor — Thu, 25 Sep 2008 09:50:17 GMT

Do you remember that really long session that Ben gave over SQL Server during the class...that would be the section I would refer you back to in regards to answering this question.

Generally we will never add an indexes haphazardly and only add them when we see a performance issue. Just adding an index on all of these fields would probably not be a good idea as they may just produce overhead or even slow things down. Dealing with dates especially if you are going to have some between operations may be a good place for an index...but this really depends on the database size, performance that you are experiencing, etc. So I can't give you a "Yes" or "No" answer here....it is more of a trial and error when dealing with performance issues.