July 11, 2002 at 3:02 am
I have a table with only two fields and i am using this table to update other table. To update other table I use first field in the where clause and second field in the set statement(to update value)
I think there is no need for an index in this case as table itself has only two field and if i create index even then I have to create index on both the field (covering index)
Anything wrong with this approach.....
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
July 11, 2002 at 5:42 am
It depends on the size of the table and how each field is used. If the table is not updated then I would consider using a clustered index to limit the overhead of the index. You can always of course do the index anyway and speed up the process but small tables may not show much if any improvement.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 11, 2002 at 6:26 am
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply