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