trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liuyu000 <>
Subject [GitHub] trafodion pull request #1575: [TRAFODION-3082] Add *populate-option* for *CR...
Date Thu, 24 May 2018 06:43:50 GMT
Github user liuyu000 commented on a diff in the pull request:
    --- 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
    +* `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 --
    Yes, thanks Dave, I've added it 😊⭐️ 


View raw message