Thursday, October 13, 2016

SQL Index

Index mostly use for filtering and finding data quickly. As we can say index is similar like book index.It’s just speed up your search.Index speed out the select and where clause but it slows down the data inputs.When index create there will no effect on data.Index not allow duplicate entry. Index prevent it.

Query:

CREATE INDEX index_cloumn_name ON tablename;

Unique Index

CREATE UNIQUE INDEX index_cloumn_name ON tablename;

Compostite Index

CREATE INDEX index_cloumn_name

on tablename (column1, column2);

No comments:

Post a Comment