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 |
|
khufiamalik
Posting Yak Master
120 Posts |
 Posted - 2009-01-30 : 01:10:08
|
| Hello All,I have a table which is having more than 1400,000 records.My query is taking 1 mili second to execute directly.I want to use Indexes to improve the query speed.Is there any way that I can use Indexes in SQL Query?Thanks in advance |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-30 : 01:43:26
|
For me to understand:You're querying 1,400,000 records in 1 mili second?That is not speedy enough?You're not using indexes?Or is this a joke?Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
AvanthaSiriwardana
Yak Posting Veteran
78 Posts |
Posted - 2009-01-30 : 01:55:39
|
| Indexes in SQL Query can be used to optimise the query execution and etc.but to be honest like webfred said there in not point of having index with your query as it executed within a minimum time.for more information please follow the link.http://www.odetocode.com/Articles/70.aspxAvantha Siriwardana |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 10:06:46
|
quote:
Originally posted by webfred
For me to understand:You're querying 1,400,000 records in 1 mili second?That is not speedy enough?You're not using indexes?Or is this a joke?Webfred
No, you're never too old to Yak'n'Roll if you're too young to die.
Maybe he is looking for results in Nano Seconds |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-30 : 17:31:18
|
quote:
Originally posted by sodeep
quote:
Originally posted by webfred
For me to understand:You're querying 1,400,000 records in 1 mili second?That is not speedy enough?You're not using indexes?Or is this a joke?Webfred
No, you're never too old to Yak'n'Roll if you're too young to die.
Maybe he is looking for results in Nano Seconds
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
|
|
How to improve Query Speed