Remove ZOrdering

[DaveLeach]

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

[shan_chandra]

@DaveLeach - you can try dropping the table and create it again instead of #1. 

[DaveLeach · Accepted solution]

Many Thanks, yes that makes sense, not sure why I was looking for an easier option