Performance Tuning DBISAM

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.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!