SQL Editor Commands
      Back to home
      1. Zetaris Help Center
      2. Using Zetaris
      3. SQL Editor Commands

      7. Partitioning

      Query performance can be improved by partitioning tables.
      What partitioning means here is that all records in a table are split into multiple chunks and these are processed in parallel.

       

      This command makes two partitions based on the "UID" column. lower/upper bound provides boundary value for the partition.

      CREATEPARTITION ON ORCL.USERS OPTIONS (

        COLUMN "UID",

        COUNT "2",

        LOWERBOUND "1",

        UPPERBOUND "6040")

       

      This partition can be removed by :
      DROPPARTITION ON ORCL.USERS