Re: how to force full table scan when index is not valid?

From: Yong Huang <yhuang_at_indigopool.com>
Date: Mon, 18 Sep 2000 17:21:53 -0500
Message-ID: <8q64o1$eon$1@news.sinet.slb.com>

There's hint FULL:

select /*+ FULL (mytable) */ somecolumns from mytable where blahblah

But you probably meant how to do this without modifying the SQL statements (because you can't e.g.). Then consider deleting statistics on these tables.

Yong Huang
yhuang_at_indigopool.com

junfan <fanjun_at_writeme.com> wrote in message news:01c02125$25ba5950$19c1790f_at_bj210276...
> dear all,
>
> while loading data into a table "barcode" with index by sqlldr in direct
> mode, the indexes of table barcode is not useable, and during the loading
> time window, my application has to search the table, so i got error
stating
> the index is unusable. I wonder if I can instruct Oracle to use full scan
> rather than index scan when index is not valid? My situation is under
> oracle 8.15i / winnt 4.0
>
> Tks in advance
>
>
>
Received on Mon Sep 18 2000 - 17:21:53 CDT