| Shailesh Khanal 2002-11-11, 2:23 pm |
| Is your query faster with the hint.
Using index hint means, there will be two locks for each
row, one on the index row and one on the data row. So if
you are selecting x no. of rows, you will see 2x locks.
>-----Original Message-----
>Hi, when i submit this query:
>
>SELECT A.i_Dsid, A.i_Aid, A.vc_Val, A.i_Val
>FROM Object_Attributes A,( SELECT DISTINCT L.i_Dsid
>FROM Object_Lookup L , Object_Attributes OA1,
>Object_Attributes OA2 (index = IND_int_Aid) WHERE (((
>OA1.i_Dsid IN (SELECT i_Dsid From ...........
>
>i get a lot of locks in my database, the reason in that
>i'm passing a optimizer hint to the server (index =
>IND_int_Aid), if i take this off i don't have any
>problems, but i can't figure out way this happens. Can
>anyone help me with this?
>Is there any issue regarding this optimizer hint? the
>server is a 7.0.
>
>Thanks a lot
>
>Miguel
>.
>
|