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 |
|
sudha12345
Starting Member
47 Posts |
 Posted - 2009-05-06 : 06:07:03
|
| i has a table named healthsystem wih fieldsDEVICE_TYPE_IDDEVICE_TYPE_DESCADD_DTADD_BYADD_PRGMLST_CHNG_DTLST_CHNG_BYLST_CHNG_PRGMon this table the column DEVICE_TYPE_ID is the primary key.now i want to index the table to increase the performance.can you guide me on which columns can i create the index?Sudhakar |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-05-06 : 06:20:08
|
| you'll have to have an idea on the kind of queries you run on the table, which ones are taking up most of the resources etc. You can identify this with a profiler trace. All this is neatly explained here,,http://www.sql-server-performance.com/tips/optimizing_indexes_general_p1.aspx |
 |
|
|
|
|
|
indexing a table