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?
Ask by Ailsa Singh
Updated 26 Sep 2016
Here 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.