Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: optimizer won't pick bitmap index
On Mon, 29 Jul 2002 18:19:37 +0200, "Mikael Kruse"
<mikael.kruse_at_ehs.ericsson.se> wrote:
...
>SELECT /*+ INDEX(q_biauto_deb_susp_dup adebsu_dup_x3) */
>
>distinct a.bi_file_id FROM Q_BIAUTO_DEB_SUSP_DUP a
>
...
Mikael,
If you alias your table ('a'), afaik you have to use the alias in the hint instead of the table name.
Jaap. Received on Mon Jul 29 2002 - 14:43:32 CDT