Dear FreeJobAlert users always type .Com after Freejobalert .Beware of duplicate websites with FreeJobAlert name.

Get Free Job Alerts in your Email - Subscribe now

.Net Interview questions home

What is Index?
Indexes are database objects designed to improve query performance.
By applying indexes to one or more columns in table or views, we could see faster data retrieval from these tables.

Explain the structure of Index in SQL server?
An index is structured by the SQL Server Index Manager as a balanced tree (or Btree). A B-tree is similar to an upside-down tree, means with the root of the tree at the top, the leaf levels at the bottom, and intermediate levels in between.
Each object in the tree structure is a group of sorted index keys called an index page.
All search requests begin at the root of a B-tree and then move through the tree to the appropriate leaf level.

What are the different types of indexes in SQL Server?
There are two types of indexes
• Clustered index
• Non Clustered index
Both types of indexes are indexes are structured as B-Trees.

Explain the difference between clustered index and non clustered index?
Clustered index:

  • A clustered index contains table records in the leaf level of the B-tree.
  • There can be only one clustered index on a table or view, because the clustered index key physically sorts the table or view.

Non Clustered index:

  • A non clustered index contains a bookmark to the table records in the leaf level.
  • If a clustered index exists on a table, a non clustered index uses it to facilitate data lookup.
  • We could create 249 non clustered indexes on a single table.

SQL Server Interview Questions

.Net Interview questions home


Tags:, , , , , , , , , , , ,

5 Responses to “SQL Server interview questions | indexes”

  • umamahesh says:

    Sir i did my M.Sc(cs),M.Tech(cse),Pursuing Ph.D from Andhra University I am searching for in software i had totally 5+years of experience in Teaching.

  • ANILA ROY says:

    I AM B COM COPLETED.5year experience in accounting section

  • nabjot pathania says:

    i am nabjot. I passed btech last year . I need ajob

  • mritunjay kumar says:

    i want to ALP APTITUDE test result 2011 send me by post
    NAME-mritunjay kumar
    ROLL NO-11015414000280

  • veeresham says:

    hi sir i did my Mcom from o.u i am searching for for in any field . i had totally 3+yrs of exp in accounting. presently i am working as accountant .

Leave a Reply

Free E-mail Job Alerts
Enter your email address: 

Find us on

Recommend on: