clustered and a non-clustered index?

clustered and a non-clustered index?

What is the difference between clustered and a non-clustered index?

View Answers

November 15, 2010 at 1:02 PM

Hi,

Here is the answer,

A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Thanks,









Related Tutorials/Questions & Answers:
clustered and a non-clustered index?
ModuleNotFoundError: No module named 'indexr'
Advertisements
java - Java Beginners
java - Java Beginners
difference between a primary key and a unique key?
Advance (Enterprise) Features
Program to display palindrome numbers between some range
Online Mysql Training
array in exception handling
prime pal - Java Beginners
Prime Numbers from range
STRING FUNCTIONS
file
Find Numbers which are palindrome and prime
Simple Fixed Size Queues
Core Java
Where can I start learning how to use TensorFlow?
Pointing last index of the Matcher
Pointing and indicating matcher using regular expression
Big Data in 2018
Synchronization in cluster - Development process
Scheduler triggering cron jobs multiple times at the scheduled time and job is retained even after deleting
Simple Fixed Size Queues
Hibernate generator Element
What is the main feature of Hibernate3?
Hibernate 5.3 features
Creating Tab Panel using GWT
Web Hosting
Understanding Hibernate <generator> element
EJB Container or EJB Server
EJB Container or EJB Server
Java Training
Understanding Hibernate O/R Mapping
Introduction to Hibernate 3.0
Which are the best big data online training institutes in India?
Install Spark on Ubuntu 18.04
MySql Open Source
Which are the best big data online training institutes in India?
Install Spark on Ubuntu 18.04
Predictive Analytics/Predictive Modeling types
Open Source DBMS
Rose India ? About Us
Predictive Analytics/Predictive Modeling types
JSP Simple Examples
Open Source Jobs
Open Source Jobs
What is Big Data Platform?
Delhi Agra tour package 2 days

Ads