--- In [email protected], "Glenn B. Lawler" <[EMAIL PROTECTED]> wrote: > > As far as the query performance, I would first evaluate whether your > query is reverting to a table scan. In other words, do your tables > have indexes which allow the query optimizer to make use of an index > instead of looking through all the records in a table. >
Hi Glen, I guess you mean that every field that is used in the where clause of a query should have an index. I've just checked and there are several fields without indexes that are used. I'll change this next week and see if it helps. Thanks, Dave. Dave Murray Delphi-En Moderator Glasgow, UK [EMAIL PROTECTED] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
