New PE2800 3.2gb Xeon, 2gb ram, sql 2005 workgroup ed.
I have a db that has been imported from access. One of the tables has a 1.8 million records. It takes a couple of minutes to pull this data up from the sql manager whereas in access it only took a couple of seconds. Other tables take longer to pull-up in sql as well. If I use access to connect to the sql server and and pull up this long table, it doesnt take as long as the sql manager but it still takes a lot longer than the access db does to pull up the same info.
Why does this very basic query take so long?
It also utlizes 50-70% of processor time while it trying to return these records.
I cant seem to find a good explaination for this behavior?
Thanks,
How is the table indexed in SQL Server? Is it the same as in Access?
