prashant.baranwal

 Profile Answers by prashant.baranwal 

• Sep 16th, 2010

 

The CREATE INDEX statement is used to create indexes in tables.
Indexes allow the database application to find data fast; without reading the
whole table.
CREATE INDEX index_name
ON table_name (column_name)

CREATE UNIQUE INDEX index_name
ON table_name (column_name)

If you want to create an index on a combination of columns, you can list the
column names within the parentheses, separated by commas:
CREATE INDEX PIndex
ON Persons (LastName, FirstName)

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

create index cr_ind on student(sid);
here i have created a index on student table on column sid