> But I only want to INDEX one - that's not altering the system (if it's not
a
clustered index)
Philip,
Although the system catalogs can be referred to in SQL
statements as if they were normal tables, they aren't
necessarily stored or managed in the same way as normal
tables internally by the DBMS. So a command like CREATE
INDEX quite possibly wouldn't work even if it was allowed.
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
