is there any stored procedure optimization techniques
actually my problem is
my stored procedure is getting information from 15 tables by joins and have some conditions in where clause
to get 15,000 records it is taking 40 sec
how can i improve the my stored procedure
thanks,
naresh
ASKED:
Apr 16 2009 6:15 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _