Hi!

I have been testing filters optimizations of my application, but I don't
understand why they are unoptimized...

I have a table with some secondary indexes (no primary index).
It has a very simple filter: "NUMBER >= 3"

Field "NUMBER" is an Integer indexed field.
I have tried the index with other fields of the same table, and all of them
are unoptimized.

Is it normal?

Thanks!

Santy,

<< I have a table with some secondary indexes (no primary index). It has a
very simple filter: "NUMBER >= 3"

Field "NUMBER" is an Integer indexed field.
I have tried the index with other fields of the same table, and all of them
are unoptimized. >>

Try running them as a live query in the DBSYS utility, i.e. something like
this:

SELECT *
FROM MyTable
WHERE NUMBER >= 3

and make sure to check the Live Result Set and Generate Plan check boxes.
You can then look at the Plan tab to see exactly what DBISAM is doing with
the filter condition in terms of using indexes, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com