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.