Posted by JeremiahOSullivan on 11/17/05 16:21

Hi,

I have a sql server database with 1.7 million records in a table, with
about 30 fields

When I run select * from tablename it can take over 5 minutes.

How can I get this time down or is it normal?

Thanks
Jerry

• Next in forum: Re: Tracking Package Execution Status
• Prev in forum: SQL Server Msg 1105, Level 17, State 2, Line 1
• Thread view: Query returning 1.7million records slow

[Reply to this message]