We are using DBISAM as third party for database. We have a huge table on which we fire select query. We are also using 'between' clause. This query is taking long time.
Could you please throw some light on,
1. Indexes (Case-Insensitive,Compression)
2. Use of UPPER keyword in query
3. Any other suggestion
for the above query.
Thanks in Advance.