|
Posted by ZeldorBlat on 11/17/05 18:16
>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?
>
Perfectly normal.
What exactly are you trying to do? If you just want to export every
row in the table to a csv file or something, use BCP or DTS. If you
only want certain rows (or fields) then I would adjust the query
accordingly.
Navigation:
[Reply to this message]
|