Indexes on a Table

One of the common task in day-to-day life to resolve the performance issues with teh SQL queries. When there is a perfrmance issue with a Query that first thing that we do is Look for the QEP (Query Execution Plan). In this if any table is going for Full table scan then we want to know if there are indexes on that table or not. So below is the piece of code which can be used to list out all the indexes.

select name from sysindexes where id=object_id('Employees')


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: