DB2 Tips n Tricks Part 56 – How to Force Query to use IXSCAN over a TBSCAN
How to Force Query to use IXSCAN over a TBSCAN
Solution:
Define Optimization Profile with guidelines accordingly.
Happy Learning & Sharing
DB2 Tips n Tricks Part 56 – How to Force Query to use IXSCAN over a TBSCAN