Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Forms 4.5 - Record Group related query
I am trying to tune a SELECT statement in a record group. When I try to
use index hint in the SELECT statement and run it throught SQL*Plus,
the performance is very much improved.
When I try to use the same statement within a record group, the index hint is totally ignored (I checked the SQL statement through the top- session monitor).
Is it possible to use index hint in a record group query? If so, how to do that? If not, what is the better way for tuning those SQLs?
Thanks for your help.
K.Murali
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Mar 13 2000 - 14:25:55 CST
![]() |
![]() |