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] )
1.4m articles
1.4m replys
5 comments
57.0k users