How to determine what Index is required by a query ?
437457Feb 11 2008 — edited Feb 11 2008Hi all,
In our application, we create some complex View with complex query.
The question is : How to determine what Index is required by the query ?
I try using SQL Tuning Advisor, but it seems I can only use it After running TOP SQL.
Is there aniway to determine the Index even Before the query under heavy load/ top sql ?
Thank you very much,
xtanto