Skip to content

Instantly share code, notes, and snippets.

@akuchotrani

akuchotrani/Example for creating an index on single column Secret

Last active July 31, 2019 07:01
Show Gist options
  • Save akuchotrani/3e8cae9923c5d794331cd9bb7c56d1cd to your computer and use it in GitHub Desktop.
Save akuchotrani/3e8cae9923c5d794331cd9bb7c56d1cd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Example for creating an index on single column
--Example for creating index on single column
CREATE INDEX my_idx_lastname
ON student(Lastname)
--Example for creating index on multiple columns.
CREATE INDEX my_idx_lastname_firstname
ON student(Lastname,FirstName)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment