Re: Oracle Lite 3.0 does not use indexes ?1?

From: <gbray1_at_my-dejanews.com>
Date: Thu, 20 Aug 1998 19:09:37 GMT
Message-ID: <6rhs9h$tnq$1@nnrp1.dejanews.com>

First thing you need to do is run a couple of explain plans. Run one with the index and one without. I would guess that you are using the cost based optimizer and you haven't updated you statistics since you've loaded the rows. This would easily cause the problem you describe. Based on old statistics, Oracle may determine that a full table scan is faster than using the index. So, update your statistics and use explain plan to tell you what is happening.

Geoffrey Bray

In article <6rhl3f$lgl$1_at_nnrp1.dejanews.com>, hr_stoyanov_at_my-dejanews.com wrote:
> Hi folks,
> I observe very strange performance problems with Oracle Lite 3.0.6.2.4
> I have a big table (about 6 million records) and a simple query like this:
>
> SELECT population_80
> WHERE population_80>1000
>
> If you index population80 (via Oracle Navigator) it takes about 5 min to
> complete the query. However, if you drop the index - only one minute. Is that
> true that Oracle Lite uses indexes only for comparison "=" and not for "<" and
> ">" ?
>
> Hristo Stoyanov
> National Decisison Systems
> San Diego, CA
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 20 1998 - 14:09:37 CDT