Performance Problems in SQL Server 2000

Hello All,
I am having acute problems with SQL Server 2000 having a single FLAT table
with more than 6,00,000 records.
It is taking almost nine minutes to get all records when I run [ select *
from myTable ] query on the same machine where DB is installed. Also, I have
created a Clustered index over a field with no Primary Key Constraints.
Any help in this context will be highly appreciated.
Thanks in Advance.
Irfan Zaidi.
Is that 6,000,000 or 600,000? Why would you want to retrieve that many rows? The time is possibly in the
client processing and not the server. Did you use QA or OSQL? If you use QA, did you try both text and grid
mode?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Irfan Zaidi" <irfan.zaidi@.pk.softechww.com> wrote in message news:eTbhCPsJEHA.3120@.TK2MSFTNGP11.phx.gbl...
> Hello All,
> I am having acute problems with SQL Server 2000 having a single FLAT table
> with more than 6,00,000 records.
> It is taking almost nine minutes to get all records when I run [ select *
> from myTable ] query on the same machine where DB is installed. Also, I have
> created a Clustered index over a field with no Primary Key Constraints.
> Any help in this context will be highly appreciated.
> Thanks in Advance.
> Irfan Zaidi.
>
|||Dear Irfan,
Please check your statistics using "DBCC SHOW_STATISTICS" if your table statictics are not update properly than update using "update STATISTICS " or "sp_updatestats".Hope it will help u .
Faheem
NETSOL