Friday, June 3, 2011

Performance issue with select statement.

Some time we have select query with proper index. Then also it gives performance issue.
I came across one situation in which same select query used many times.
with proper index and where condition. Still it was giving performance issue.

We have not find in option to improve code.

But we come to know some time where condition has blank value. Which causes more time in sequential read.

No comments:

Post a Comment