Query taking forever...

From: Tiger Woods <clintonn_at_meb.co.za>
Date: Tue, 5 Aug 2003 16:33:01 +0200
Message-ID: <3f2fc081$0$225@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 - 09:33:01 CDT