Link to home
Start Free TrialLog in
Avatar of Amour22015
Amour22015

asked on

TSQL - What is faster

Hi Experts,


This is more of an informational question

I have a co-worker that said that I should not:
Right click a table and take the option of: "Select top 1000 rows"
that it take more time to do this.

The co-worker said that it is best to:
just do new query and then type in your select statement.

But one would have to know all the columns in the select statement to do this?

So what approach is best?

Thanks for helping.
ASKER CERTIFIED SOLUTION
Avatar of dsacker
dsacker
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Amour22015
Amour22015

ASKER

But that would run all rows and might take awhile?

maybe Select top 1000 *  From table?

So doing just the select statement is faster?

Thanks
Is not even a speed matter. Do you really want to return all rows or only the first 1000?
If you want all rows then TOP 1000 can't be a solution for you.
Ok so just the select command is faster, thanks