Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Query from Forms not using Index
Hi, The following query is produced by an Oracle Forms application :
SELECT {multiple_columns)
FROM gg_inbox
WHERE ind_order_id = :1
ORDER BY entered_gg_date DESC;
this query does a full table scan of the table in question when there is an index associated with ind_order_id column. When I run the query manually in SQLPlus like below :
SELECT {multiple_columns)
FROM gg_inbox
WHERE ind_order_id = '111236441'
ORDER BY entered_gg_date DESC;
the index is used and the result comes back instantly. Does anybody know why it is not using the index in the Forms application? Any help would be greatly appreciated.
Mark. Received on Tue Apr 19 2005 - 03:35:44 CDT