How do I index a database column *

Question

Hopefully, I can get answers for each database server.

For an outline of how indexing works check out: http://stackoverflow.com/questions/1108/how-does-database-indexing-work

Answer

The following is SQL92 standard so should be supported by the majority of RDMBS that use SQL:

CREATE INDEX [index name] ON [table name] ( [column name] )

< br > via < a class="StackLink" href=" http://stackoverflow.com/questions/1156/" >How do I index a database column< /a>

Share on Google Plus

About Cinema Guy

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.