开发者_JAVA技巧When does CBO compiler use Range scan in oracle??
When there's a suitable index on the table - and the calculated cost of the plan is the least (or if the query is hinted to scan the index).
开发者_JAVA技巧When does CBO compiler use Range scan in oracle??
When there's a suitable index on the table - and the calculated cost of the plan is the least (or if the query is hinted to scan the index).
精彩评论