You can find the names of indexes by using sp_helpindex. This procedure takes a table name as a parameter.
To list the indexes for the authors table, enter:
sp_helpindex authors
To update the statistics for all of the indexes in the table, enter:
update statistics authors
To update the statistics only for the index on the au_id column, enter:
update statistics authors auidind
