Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: utilize index
Hello Sybrand!
In fact I've tried to use alias in hint but It didn't work too. After your message I've tried again. So now it works. Probably I misspelled in hint last time :(( Unfortunatly Oracle doesn't care about that, you know.
Thanks again, your advices are really heplful.
Rgds, Vadim Grepan
Sybrand Bakker wrote:
> One can see what has happened.
> Using a table alias, you need to use the table alias in your hint.
> Also, most likely the lastname column is not being indexed and as there has
> to be a full table scan on the driving table anyway, the hash join was
> supposed to be cheaper.
> This might be true, in the past I have conducted experiments, and indeed the
> full table scan in combination with hash join did consume less I/O
> So a set autotrace on explain stats or a true trace would provide more
> conclusive evidence. However first you should change the tablename in the
> hint into that alias.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
[..skip..] Received on Mon Feb 26 2001 - 07:20:46 CST