How to do database column indexing?

Question

Revathi Parvathi · Answer

Good.

Tarun Kumar · Answer

To create Indexing we need a table - so we assume that you already created a table. After that create an Index on the table that don't allowed duplicate values the table you already have.
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.

forum

How to do database column indexing?

Can you answer this question?

2 Answers