Link to home
Start Free TrialLog in
Avatar of chongchian
chongchianFlag for Singapore

asked on

Oracle 10g with index slower than no index for select

Hi Experts,

I am doing an experiment of a dataset of over 100,000 rows of record where the where condition are 100% unique and sorted by default in the database.

However, when I ran my select query, it seemed that queries with index are actually slower than queries without index on that field.

That field is based on NUMBER(8,4) datatype. Would appreciate any advice. pls.
ASKER CERTIFIED SOLUTION
Avatar of Akenathon
Akenathon
Flag of Uruguay image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If the number of rows returned by the query are less... rebuilding the index will help.

alter index <indexname> rebuild