The full table scans on the hash joins and the outer join are killing you.
- Make sure the tables are analyzed.
2.. Make sure the where clause fields are indexed on the left side
of the index.
- Break apart the query if needed using pl/sql nested loops or
some other procedural language.
- Call functions in your sql to get results to break apart the
the sql statement.
- Hints may help.
Roman Gelfand <rgelfand_at_masmid.com> wrote in article <6qe6b9$cg$1_at_news.monmouth.com>...
> Attached, is a copy of tkprof listing of a select statement.
> Keep in mind fields in where have indexes and of which all objid fields are
> unique sorted indexes.
>
> How do tune this statement?
>
>
>
>
>
Received on Mon Aug 10 1998 - 20:17:25 CDT
