topic Re: Remove ZOrdering in Data Engineering

Remove ZOrdering

DaveLeach — Tue, 09 Jan 2024 11:36:20 GMT

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 — Thu, 11 Jan 2024 20:01:46 GMT

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

DaveLeach — Fri, 12 Jan 2024 12:02:39 GMT

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