Thank you all for the suggestions. SampleID is the PK.

Hi Lynn,

Code has been written some 3rd party consultant. Is there a way to convert it into normal sql?

Thanks ,
Sam

Thanks for taking time. Thanks a lot.

Thanks Lynn. One more thing, I want to ask is that, how can we make the DEV team understand why not to do the sorting at DB layer and can...

The problem is, running the query individually for 1 user it is performing well. however, when the same sp/sql stmt is execute with 60 concurrent connections then the average response...

Thank you Gail.

Thanks a lot Jeff.

Any thoughts pl?

Thanks Gail. Any thoughts on the term SARGable? I feel the word SARGable means "Searchable" based on condition or not. Is that correct?

Thanks aaron.I want to understand the basics of how execution happens w.r.t to the query I shared.
However,  got to know other things. Thank you all.

Thanks for those valuable inputs Grant and Jeff. Learn somethings which never known. thanks a lot for taking time.

Great guidelines. Thanks Dim and Grant.