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
