Dawn,

>I have a table with 1.5 mil records. When I browse or query it is slow. I have an index on every field I query on. I already ran sys(3054,11) and I am fully optimized. Help!!!!

A few questions:

1) If you just USE table and then BROWSE, is it slow, or are you setting an index order or perhaps a SET FILTER?

2) Please post the SQL SELECT statement for the query that is slow.

3) How slow is it?