View Single Post

   
  #4 (permalink)  
Old 02-29-2008, 01:57 PM
paulmac106
 
Posts: n/a
Default Re: Optimizing Stored Procedure with Datetime parameter

I've read that perhaps the sp is not using the index. The table i'm
searching is a joined table in the sp...Do you know how i can force it
to use the index? Then name of the index is IndexDate

thanks,
Paul

Reply With Quote