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 |
|
binto
Yak Posting Veteran
59 Posts |
 Posted - 2010-01-06 : 05:13:55
|
| HiPlease help meHow a select, insert, delete, update queries can be fastened?Thanks & RegardsBinto Thomas |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 05:15:36
|
| what all indexes you currently have on table? what all columns you retrieve,insert & modify most? |
 |
|
|
binto
Yak Posting Veteran
59 Posts |
Posted - 2010-01-06 : 05:24:02
|
| I have created three non-clustered indexes on the table employee.I have around seven million data in my table.Visakh, please help me.Thanks & RegardsBinto Thomas |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-06 : 05:37:24
|
Each SELECT or INSERT or UPDATE or DELETE query has to be analyzed in particular.It is nearly impossible to give a general advice on how to speed up all queries.So you should come up with a particular query and all informations about it (table structure, indexes, query, ...).
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
How to fasten Queries?