Hopefully, I can get answers for each database server.
For an outline of how indexing works check out: How does database indexing work?
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] )
2.1m questions
2.1m answers
60 comments
57.0k users