Check out example codes for "sql create index". It will help you in understanding the concepts better.

Code Example 1

CREATE [UNIQUE] INDEX <index name> ON <table name> (<column(s)>);

Code Example 2

CREATE INDEX index_name
ON tableName (tableColumn);

Learn ReactJs, React Native from akashmittal.com