Can any one tell me how can I index columns, when our data-Set increases in size.
Because whenever I click on different links I didn't get the correct pages.
So, please tell me how column indexing works at a database agnostic level.
How to do database column indexing?
197508-Apr-2016
Updated on 26-Sep-2016
Revathi Parvathi
26-Sep-2016Tarun Kumar
11-Apr-2016Here we will create two indexs first will allow duplicate values and the second one will not allow duplicate values, like this:
This Index allowd duplicate values, use like this:
CREATE INDEX indexName1 ON tableName(columnName)
This Index don't allow duplicate values, use like this:
CREATE UNIQUE INDEX indexName2 ON tableName (columnName)
After that create a Clustered Index, like this:
CREATE CLUSTERED INDEX clusterIndexName on SALES(ID);
and at last to create Non-clustered index, use like this:
CREATE NONCLUSTERED INDEX nonClusterIndexName ON SALES(ProductCode);
I hope the above solution will be helpful for you.