Open record sets

[rsrinivasan]

Hi all,
I am using SQL server 2000.When i right-click on table-name and click open option in Query analyzer, it returns one million record within 10 seconds. But when i select recorde through query "Select * from tablename", it takes 10 minutes. What is difference between this?

Thanks,

[debasisdas]

is the Query analyzer returning the records or only the count of records ?

[BHTanna]

Actually, both are taking the same time.. But thru Enterprise manager, it just starts desplaying as records are fetched...

Same can be done thru Query Analyzer also, if u set Results in Text.

But in the both situations, all records will take same time.

[rsrinivasan]

Actually, both are taking the same time.. But thru Enterprise manager, it just starts desplaying as records are fetched...

Same can be done thru Query Analyzer also, if u set Results in Text.

But in the both situations, all records will take same time.

I set Results in Text and executed the select query. But it also takes 18 minutes.

[BHTanna]

I mean, It will start displaying the records as its fatched...

It wont wait entire query to get executed.. Like enterprise manager..

[ck9663]

The Enterprise Manager actually executed the entire query but did not display it all. Query Analyzer executes and displays everything. Even if you scroll it down, the value has been returned already and not in the cached.

Enterprise Manager fetch it as you scroll down.

-- CK