Creation of Index is fine. But what is the term unique index referring to. Is it same as index. In what situation will one create this unique index? Can someone explain this by an example?
Printable View
Creation of Index is fine. But what is the term unique index referring to. Is it same as index. In what situation will one create this unique index? Can someone explain this by an example?
See creation of indexes are fine in some situation i.e when the data retrival from the table is less than 5%, otherwise a FTS is occuring there is no need of index.
unique index and index is different, in unique index the keyword unique is used while creating index but not so in case of simple index
in unique index the values should be unique i.e no duplicate but can exist in non unique index. A unique index can contain null values as two null values is not equal
A very detailed explanation of Usage of Unique Index . I should really thank parthokonar1 for answering me in detail.