> How many rows are returned by the query in reality ?
> Does the table *table1* have an index on the column *var1*
> in your centura sqlbase ?
... and did you do a "vacuum analyze"? What is the schema? What is the
query? What is the result of "explain" for that query?
All of these things are relevant for any inquiry regarding poor
performance. I'm sure you will get acceptable performance once things
are adjusted.
- Thomas