Package helpers :: Module AddIndices
[hide private]

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

Classes [hide private]
Create table indexes for all programmes.
Variables [hide private]
  __package__ = 'helpers'