Oracle Lite 3.0 does not use indexes ?1?

From: <hr_stoyanov_at_my-dejanews.com>
Date: Thu, 20 Aug 1998 17:06:55 GMT
Message-ID: <6rhl3f$lgl$1@nnrp1.dejanews.com>

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 Received on Thu Aug 20 1998 - 12:06:55 CDT