Re: Index Files

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

Some methods we have used to improve performance other than the ones
mentioned already:  If your working with large tables in Oracle with a lot
of manipulation increasing the sort size using ALTER SESSION can help speed
things up.

Also, I think it's Oracle 8i and later that allows you to use parallelism.
Adding a Parallel hint to slow DML SQL statements can kickem in the pants
and get them moving.  This works really well on large inserts.  Make sure
you know your hardware configs for this as the parameters will need the
correct degrees of parallelism set.  I recommend checking with your DBA if
in doubt.

-Alan


-----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