How to have booth ZOEDER and VORDER on a single table

Question

I have a table called Human and I want to apply optimization technique of Zorder on Region and Area with VORDER on the whole table.

Can anyone suggest a sample code or explain what is Predator as per the documentation

OPTIMIZE <table|fileOrFolderPath> WHERE predicate 
   [ZORDER BY (col_name1, col_name2, ...)];

OPTIMIZE <table|fileOrFolderPath> WHERE predicate 
   [ZORDER BY (col_name1, col_name2, ...)];

Answer 1

If you look into this documentation, you'll see the following option:

OPTIMIZE <table|fileOrFolderPath> WHERE <predicate> 
  [ZORDER  BY (col_name1, col_name2, ...)] VORDER;

But if you have VOrder set as a table property or as a session flag (see linked docs), then it will be also used if you omit it when doing OPTIMIZE.