Monday, June 27, 2011

INDEX

What is index?
An index  is a pointer for to a location of data.The purpose of index is to make sql queries to run faster
 syntax:-
CREATE [UNIQUEINDEX index_name ON
table_name(column_name[, column_name...])
TABLESPACE table_space;
 
Normal Index?