i have a database very improtant from productio point of view. i had run trace on the server and collected the queries, can you please guide that how i should learn that which indexes on the tables are good and which not. there are some indexes which are redundant.please guide me how i can improve the performance after creating and dropping the useless indexes. thanks
