Alan,

An index is activated at the same time it is created.

The index can then be deactivated/re-activated as nessessary (it's not
the most common occurance, though).


Sean