Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
msrs
32 Posts |
Posted - 2007-06-18 : 01:42:19
|
Dear All, |
|
Kristen
Test
22859 Posts |
Posted - 2007-06-18 : 02:21:34
|
"it is taking around 20 sec for 41000 records...."Maybe your network is taking that long to "ship" the 41,000 records across the network?How long does a SELECT COUNT(*) FROM VRPT_FIN_GL_SEGMENTSDATA WHERE ...take?Kristen |
|
|
msrs
32 Posts |
Posted - 2007-06-18 : 02:50:23
|
without where condition it is taking 14 sec |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-18 : 05:23:11
|
Is that 41,000 records, or more?You need to compare like-with-like, so you should use the same condition as before to get 41,000 records (I don't know if you were using a WHERE condition, or not )Kristen |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-09 : 05:29:38
|
Or he realized SQL is not his cup of tee and decided to leave the business? E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|