For index

Is there any way I can findout all the columns and it's table which used in
stored procedure in the where clause and don't have indexes on it ? If yes
then how can I finout out.
Thanks
Look at the Index Tuning Wizard. That would be a great tool for you to
learn how to use.
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:188538E6-A0AA-4750-98DA-AE4DE36ECB81@.microsoft.com...
> Is there any way I can findout all the columns and it's table which used
in
> stored procedure in the where clause and don't have indexes on it ? If yes
> then how can I finout out.
> Thanks