Re: Query taking forever...

Can you use the trace facility to generate an execution plan and statistics for your query? Details of how to do this are in the tuning guide. This will show how Oracle interprets your query.

Also, what indexes are set up on the swpro table? Do you generate optimizer statistics regularly?

Richard

"Tiger Woods" <clintonn_at_meb.co.za> wrote in message news:3f2fc081$0$225_at_hades.is.co.za...
> Hi all.
>
> I have a query that is taking forever (11 - 12 minutes on the initial run)
> and its query a table that has just less than 74 000 records.
> The statement is as follows:
>
> SELECT casenum, flags, starter, casedesc, procflags,
to_char(next_deadline,
> 'YYYY-MM-DD HH24:MI'), outstanding_mail
> FROM swpro.case_information
> WHERE node_id = 1
> AND proc_id = 26
> AND casenum >= 2
> ORDER BY casenum
>
> The Sql is generated by the Staffware Application.
>
> Any idea's on this...
>
> Thanks
>
> Clint
>
>
Received on Tue Aug 05 2003 - 10:22:20 CDT