Re: INDEXES ? DO I have to activate it?

From: <bpage_at_my-dejanews.com>
Date: Fri, 05 Jun 1998 19:55:47 GMT
Message-ID: <6l9ig4$lsu$1@nnrp1.dejanews.com>

In article <dolans.897065326_at_stripe.Colorado.EDU>, dolans_at_stripe.Colorado.EDU (Sean Dolan) wrote:
>
> I have just created an index on a column of a table. Do I need to activate
it somehow so that Oracle knows to use it? Or does it do it itself? It's on Oracle 7.3.4.
>
> Thanks,
> Sean Dolan
>

If you are using CBO, you have to analyze the table for the new index to be used.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 05 1998 - 14:55:47 CDT