I have an application with a select statement that takes 4-5 minutes to complete. I used sql spy to view the statement that is giving me the problems. I then ran the statement in SQL*Plus and it takes several minutes to complete there also.
Do you know of anything I can do to speed this up? Note there are only 4133 rows in the table.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 25 14:27:19 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.50 - Production
With the Partitioning option
JServer Release 8.1.7.4.50 - Production
SQL>
SQL> desc course_bank;
Name Null? Type
----------------------------------------- -------- ----------------------------
INSTIDQ NOT NULL CHAR(2)
INSTID NOT NULL CHAR(8)
INSTCD NOT NULL CHAR(3)
COURSE NOT NULL CHAR(15)
PFLG CHAR(1)
MEMO VARCHAR2(255)
LAST_MOD_USER VARCHAR2(30)
LAST_MOD_DATE DATE
SQL>
SQL> SELECT course_bank.instidq, course_bank.instid, course_bank.instcd,
           course_bank.course, course_bank.pflg, course_bank.memo,
course_bank.last_mod_user, course_bank.last_mod_date,
0 itemhandle, 0 c_color1
FROM course_bank
WHERE course_bank.instidq = '73'
AND course_bank.instid = '003100'
AND course_bank.instcd = ' '
ORDER BY course_bank.pflg ASC,
course_bank.course ASC;