Nolock is not used.

we havent used inbuilt function also.

there is date conversion and comparison between a table column and input parameters.

i forgot to mention it is compared with a encypted column also.

anu suggestion based on above details.