Module AddIndices
source code
Create table indexes.
Archive table indexes are defined in the script WSA_Indices.sql - this
application parses that static script, and then invokes index creation on
the database server, one by one, logging results. This application is
provided for routine, GUI-driven operation of the archive.
To add an index to any archive table, edit the script WSA_Indices.sql
and then either play the script in Query Analyser, or run this (remember
to re-parse the schema browser documentation to pick up newly indexed,
and therefore highlighted, attributes!).
Author:
R.S. Collins
Organization:
WFAU, IfA, University of Edinburgh
Contributors:
J. Bryant, N.C. Hambly, E. Sutorius
|
Indexer
Create table indexes for all programmes.
|