Re: Force indexes in a query

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use a hint. Hint's must appear immediately after the SELECT and are nothing more than a special comment that begins with the + sign. You can find them all in the developers guide.

select /*+ index(address_table addresses_index) */ name, address
from addresses_table;

"�lvaro Palma Aste" <queria_direccion_at_el.perla?> wrote in message news:9vli2c$7vk$1_at_news.cec.uchile.cl...
> Hi, How could I force a query in order to use an specific index, I
> mean, something like
>
> select name, address
> from addresses_table
> "using index addresses_index" (I know the sintax is wrong, but
> that�s the idea)
>
> Thanks a lot for your help
>
> --
> Atte.
> �lvaro Palma Aste
> Grupo de Ing. Biom�dica
> Depto. de Ing. El�ctrica - U. de Chile
apalma_at_cec.uchile.adivina

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPB5R2mm5A4kkb4ZsEQIGuACfZFb3Ba2EBckNXXqa4NCFHFiQc+IAoMbt jDQGr7Ad+6m8IsMuYeUqe54S
=p2Yr
-----END PGP SIGNATURE----- Received on Mon Dec 17 2001 - 21:13:17 CET