Different execution paths
Hello:
We have 2 identical databases, with the same optimizer settings, one in production and the other in staging. But some of the queries have different execution paths. There is nothing dissimilar between them, as far as I can tell. Why does this occur ?
We have 2 identical databases, with the same optimizer settings, one in production and the other in staging. But some of the queries have different execution paths. There is nothing dissimilar between them, as far as I can tell. Why does this occur ?
Also, this query:
select * from site_asset_tags where tag_id = :1 has this plan -> CHOOSE SELECT STATEMENT Cost = 47 1.1 TABLE ACCESS BY INDEX ROWID SITE_ASSET_TAGS 2.1 INDEX RANGE SCAN SITE_ASSET_TAGS__IX1 but this query select * from site_asset_tags where tag_id in ( :1, :2) does a full table scan. CHOOSE SELECT STATEMENT Cost = 56 1.1 TABLE ACCESS FULL SITE_ASSET_TAGS SITE_ASSET_TAGS__IX10