Monday, May 11, 2009

What should be Limit for BULK COLLECT?

Based on this article, 25 is a good number. I think if expected number of rows is not too many then LIMIT should not be used. If a query could return more than 1000 rows then it might be better to use LIMIT.

No comments:

Post a Comment