2 votes 2 votes State TRUE or FALSE. "In Indexing,the number of ordering field (field based on which records in data file and its corresponding index file are sorted) should always be 1". Please support your answer with explanations ... Databases databases indexing + – vignesh asked Apr 26, 2017 retagged Aug 5, 2017 by Arjun vignesh 387 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply akash.dinkar12 commented Apr 26, 2017 reply Follow Share True, we can have more than 1 index on same data file. For eg, There is database file of college in which there two attributes(student Roll_no, Student_name). Now in order to make searching faster, we will try to make index on Student Roll_no, since Student Roll_no is primary key, we will call this index primary index. This primary index is going to be useful when search is based on primary key and let if we have many search requests which are other than based on primary key,(for eg: search is based on Student_name) then we have to make index on student_name attribute also.This index is known as dense index 1 votes 1 votes Nachiket Karambelkar commented Aug 30, 2017 reply Follow Share I still have doubt in this..... Please provide in detail explanation... 0 votes 0 votes Please log in or register to add a comment.