Hi, I am trying to demonstrate the effectiveness of ZOrdering but to do this would like to remove the existing ZOrdering first. So my plan is:
1. Remove existing ZOrdering
2. Run a query and show the explain plan
3. Add ZOrdering to column used for Joins
4. Rerun query and show revised plan.
Question is how do I remove the existing ZOrdering?
Many Thanks
Dave