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 |
|
atulbharadwaj
Starting Member
11 Posts |
 Posted - 2010-01-04 : 08:20:00
|
| Hi all, i am using a table which is having millions of records. i can't apply index on table so can some one tell me that how can i select million of records in seconds while i m running query on live server now it is taking more then one minute to select 1 million recordsatulatul |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-04 : 08:48:28
|
Why do you cannot apply the needed index on that table?Why do you have to take 1 million records?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
atulbharadwaj
Starting Member
11 Posts |
Posted - 2010-01-04 : 09:10:55
|
i can't apply index because my filering records are not unique my table is updating daily with thousends of records that y its size is bigquote:
Originally posted by webfred
Why do you cannot apply the needed index on that table?Why do you have to take 1 million records?
No, you're never too old to Yak'n'Roll if you're too young to die.
atul |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-04 : 09:30:09
|
When you say filering records - do you mean filtering records?Can you give a sample of that query?My second question wasn't "why is that table size big?" it was "why do you have to select a million records?" i.e. why do you need a million records as a result of a query?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-04 : 13:53:31
|
| a lot of factors can effect the speed of the return , as a starting point have you tried to do the SELECT usiing SSMS and see the execution plan. (it would be useful to see the select statement )Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
faster way to select a table