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