1 votes 1 votes Databases databases indexing + – bahirNaik asked Jan 8, 2016 • retagged Aug 5, 2017 by Arjun bahirNaik 943 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 3 votes 3 votes Answer : B A clustered index determines the order in which the rows of the table will be stored on disk – and it actually stores row level data in the leaf nodes of the index itself. A non-clustered index has no effect on which the order of the rows will be stored. http://www.programmerinterview.com/index.php/database-sql/clustered-vs-non-clustered-index/ bahirNaik answered Jan 9, 2016 • selected Jan 17, 2016 by Pooja Palod bahirNaik comment Share Follow See all 4 Comments See all 4 4 Comments reply Registered user 48 commented Sep 19, 2018 reply Follow Share Clustering and Primary index are same? Please correct me if I'm going wrong somewhere. In primary Index, ordering key field is used as key field.That is the key used to sort the records. If the ordering key fields are not unique then a different key is used to index the records, this is clustering indexing.In both cases records are order according to key (primary/clustered). A file can have at most one physical ordering field, so it can have at most one primary index or one clustering index, but not both. Primary indexing is not same as clustering index right? Excerpt from navathe. A primary index is specified on the ordering key field of an ordered file of records. Recall from Section 17.7 that an ordering key field is used to physically order the file records on disk, and every record has a unique value for that field. If the ordering field is not a key field—that is, if numerous records in the file can have the same value for the ordering field—another type of index, called a clustering index, can be used. 0 votes 0 votes Dharmendra Lodhi commented Oct 21, 2018 i edited by Dharmendra Lodhi Oct 21, 2018 reply Follow Share Primary index :in a sequentially ordered file, the index whose search key specifies the sequential order of the file. Also called clustering index The search key of a primary index is usually but not necessarily the primary key. from: https://www.cse.iitb.ac.in/~sudarsha/db-book/slide-dir/ch12.pdf 0 votes 0 votes akash.dinkar12 commented Oct 23, 2018 reply Follow Share @Dharmendra Sir See this:https://gateoverflow.in/85558/doubt-on-primary-indexing-and-clustred-index?show=85558#q85558 0 votes 0 votes Dharmendra Lodhi commented Oct 23, 2018 reply Follow Share Clustered index : index on ordering field. Primary Index : Index on ordering field and also it should be key field. so above statements we can conclude all primary index are clustered index but not vice-versa. Secondary index : index on unordered field i.e. non-clustering index. Sparse index : contains index records for only some search key values. Applicable when records are sequentially ordered on search key. Dense Index : Index record appears for every search key value in the file. 2 votes 2 votes Please log in or register to add a comment.