|
Posted by Joe Weinstein on 11/18/05 02:00
JeremiahOSullivan@gmail.com wrote:
> 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
It sounds fast actually. This isn't something you should be doing
very often anyway. What are you doing with all that data out of
the DBMS?
Joe Weinstein at BEA Systems
Navigation:
[Reply to this message]
|