Create an Index: It can be created in one or more columns, either individually or together. Such as If you've created a table named 'A' with a column 'ab' and want to create an index on this column to facilitate efficient searches for text such as 'Shobha' within the 'ab' column. You can use the following command. CREATE INDEX index_name ON A(ab);
Syntax:
CREATE INDEX index_name ON table_name(column_name);