Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Forms 4.5 - Record Group related query

Forms 4.5 - Record Group related query

From: <murali09_at_my-deja.com>
Date: Mon, 13 Mar 2000 20:25:55 GMT
Message-ID: <8ajisd$bot$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US