create index idx [as active | inactive] on ... ----------------------------------------------
Key: CORE-5981 URL: http://tracker.firebirdsql.org/browse/CORE-5981 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Volker Rehn Priority: Minor Syncing metadata of two databases: If the master db has inactive indices which are missing in the target, on creation they will be activated in the target db, do a full data scan, and only afterwards they can then be deactivated by alter index. An optional "as active/inactive" clause would give more control over when an index is actually built. Oracle and MySQL have visible/invisible for indices, but that only removes the index from being used by the optimizer, it still performs a data scan on creation. Apparently the SQL standard does not regulate index creation. The syntax could be CREATE [UNIQUE] [ASC[ENDING] | DESC[ENDING]] INDEX indexname [AS ACTIVE | INACTIVE] ON tablename {(col [, col ...]) | COMPUTED BY (<expression>)}; ACTIVE being the default as it is now. Similar to how triggers are defined. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel