Highly skilled in Oracle Database query rewrite for Materialized view and Partition pruning for Partition tables
Budget: ₹12,500 – ₹37,500 INR
I have 2 problems
In my DWH environment ,
1. the query is not going for a partition pruning instead it is going for full partition scan,
2. some queries dont go for materialized view with query rewrite enabled , instead the read the base table of the MV.
I need someone who is specialized in Partition pruning , Bloom filters/ Query rewrite for MV and can help fix the issue.
In my DWH environment ,
1. the query is not going for a partition pruning instead it is going for full partition scan,
2. some queries dont go for materialized view with query rewrite enabled , instead the read the base table of the MV.
I need someone who is specialized in Partition pruning , Bloom filters/ Query rewrite for MV and can help fix the issue.