Fred,
You need to look at the query plan and see what indexes the select is or is not using.
Are you saying that adding an index on a column on that table takes 10 hours? That is unbelievably slow.
>the sales table has 11 mill rows. if I add one index it takes about 10 hours to run.
>
>Queries work very fast on other tables. It only works slow on 1 table. The CPU usage goes over 60% whenever I run a query on the sales table. even to return 10 rows.