HOW TO DO DATABASE COLUMN INDEXING?

Ailsa Singh

Total Post:24

Points:168
Posted by  Ailsa Singh
 901  View(s)
Ratings:
Rate this:
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.
  1. Tarun Kumar

    Post:214

    Points:1642
    Re: How to do database column indexing?

    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.

  1. Revathi Parvathi

    Post:1

    Points:7
    Re: How to do database column indexing?

    Good.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!