SQL Backup Pro
Getting started with SSIS - Part 1: Introduction to SSIS
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.
Loading

Ask in the public forum

Ask your questions in a public forum

My Blog Posts

Write SQL amazingly fast with SQL Prompt
  • Non-Clustered Index and Index

    what is the difference between Non-Clustered Index and Index. I am tired of finding any huge difference between them.

    So can you guys please help me out in this.

    · Index

    guptaS
    1186 · 0% · 9

2  Replies  

Subscribe to Notifications
  • I guess you meant Non-clustered Index and Clustered Index. Is that right?

    Since you have mentioned any huge difference between them, I am not sure what have you found and understood about them till now.

    The first and most basic and notable difference between them is the Leaf level Page of a Clustered Index is the data itself where as the leaf level page of a clustered index contains the pointer to the data.

    There are few other differences, but not sure what are those that you are already know.

    Bru Medishetty
    321 · 0% · 76
  • In other words, when you create a clustered index, the table itself is sorted in the specified order. When you create a non clustered index, a new index table is created that contains the index key and points back to each row in the table.

    Jacob Sebastian
    1 · 100% · 16868

Your Reply


Sign Up or Login to post an answer.

Managed Windows Shared Hosting by OrcsWeb

Copyright © Beyondrelational.com