create-table-order-by.md
Invalid for external tables, specifies columns from the SELECT
list on which to sort the superprojection that is automatically created for this table. The ORDER BY
clause cannot include qualifiers ASC
or DESC
. Vertica always stores projection data in ascending sort order.
If you omit the
`ORDER BY`
clause, Vertica uses the SELECT
list order as the projection sort order.