Indexes in SQL Server

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')