Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OPTIMIZER / ANALYZE INDEX
Hi,
a. Your index has maybe poor selectivity or try to user analyze index with
sample clause or analyze index compute statistics...
b. Send please index_name,table_name and select text with your hint
c. Analyze index index_name delete statistics
Peter Rak
VSZ Kosice
Slovak Republic
pfrancescani_at_compuserve.com wrote:
> After creating an index on a date column on a 3 million row table, I select
> count(*) from table where date column > whatever. The optimizer uses the
> index. I run 'analyze index <index name> estimate statistics' . Now the
> optimizer does not use the index , even if I try to force it with a hint.
> This is happening in 7.3.3 and 8.0.4 on Sun. This does not happen on a
> similar table/index with fewer rows.
>
> If anyone can help, what I'd like to know is : a. Why doesn't the optimizer
> choose the index after I've analyzed the index? My understanding is that
> analyzing objects should help the optimizer. b. Why wouldn't my hint work?
> c. How can I reset what the 'analyze index' statement does without dropping
> and re-creating the index?
>
> Thanks
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Wed Jun 10 1998 - 03:31:47 CDT