[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Index Files

You want to make sure that there is an index on every field referenced in
the 'where','and','having','group by' clauses. The fields referenced from
'select' do not need indexes, they are just fields for display. SQR doesn't
use the index, the db engine uses them. Correct indexing is THE MOST
important factor in the speed of queries.

ac

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Wayne C. Findley
Sent: Friday, June 07, 2002 3:41 PM
To: SQR-USERS@list.iex.net
Subject: Index Files


Hi Everyone,

If I create indexes to match every select statement in my SQR would the SQR
run faster seeing that I'm working with mammoth tables?

How would the SQR know to use the index?

Anxious to get process moving faster.


Help!

Wayne