From codereview-return-6977-apmail-trafodion-codereview-archive=trafodion.apache.org@trafodion.apache.org Wed May 23 18:02:58 2018 Return-Path: X-Original-To: apmail-trafodion-codereview-archive@minotaur.apache.org Delivered-To: apmail-trafodion-codereview-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F1F8E18254 for ; Wed, 23 May 2018 18:02:58 +0000 (UTC) Received: (qmail 4793 invoked by uid 500); 23 May 2018 18:02:58 -0000 Delivered-To: apmail-trafodion-codereview-archive@trafodion.apache.org Received: (qmail 4757 invoked by uid 500); 23 May 2018 18:02:58 -0000 Mailing-List: contact codereview-help@trafodion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: codereview@trafodion.apache.org Delivered-To: mailing list codereview@trafodion.apache.org Received: (qmail 4746 invoked by uid 99); 23 May 2018 18:02:58 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 May 2018 18:02:58 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 2AD90E09F5; Wed, 23 May 2018 18:02:58 +0000 (UTC) From: DaveBirdsall To: codereview@trafodion.apache.org Reply-To: codereview@trafodion.apache.org References: In-Reply-To: Subject: [GitHub] trafodion pull request #1575: [TRAFODION-3082] Add *populate-option* for *CR... Content-Type: text/plain Message-Id: <20180523180258.2AD90E09F5@git1-us-west.apache.org> Date: Wed, 23 May 2018 18:02:58 +0000 (UTC) Github user DaveBirdsall commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1575#discussion_r190345322 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -1755,6 +1760,23 @@ for the first column, the values in the second column are used to order the rows rows occur in a non-unique index, their order is based on the sequence specified for the columns of the key of the underlying table. For ordering (but not for other purposes), nulls are greater than other values. +* `populate-option` + +** `NO POPULATE` ++ +specifies that the index is not to be populated when it is created. ++ +The index’s partition(s) are created, but no data is written to the index, and it is marked “offline”. You can drop an offline index with the DROP INDEX statement. +The DROP TABLE statement also drops offline indexes of the specified table. +DML statements have no effect on offline indexes. ++ +If an index is created with the intention of using it for a constraint, it must be populated before creating the constraint. +You can populate an offline index and remove its offline designation by using the POPULATE INDEX utility. + +** `POPULATE` ++ +specifies that the index is to be created and populated. --- End diff -- You may want to mention that this is the default option. ---