1 votes 1 votes Is it possible in general to have two primary indices on the same relation for different search keys ? Explain your answer. Databases korth databases indexing descriptive + – akash.dinkar12 asked Apr 1, 2019 akash.dinkar12 1.4k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes No it's not possible to have more than one primary index on same relation. In primary index the search key is the primary key/Alternate key and it is physically ordered in DB, so other keys will automatically be unordered hence at most 1 primary index is possible for a relation. noob_coder answered Jun 22, 2019 noob_coder comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes If two or more attributes are ordered then yes. Example: Roll Number(unique within institute) and enrollment number(unique within Mumbai University) of relation for an institute. sakharam answered Sep 3, 2019 sakharam comment Share Follow See all 15 Comments See all 15 15 Comments reply Show 12 previous comments srestha commented Sep 3, 2019 reply Follow Share @sakharam Key cannot take duplicate values right?? Otherwise tell me which key can take duplicate values?? 0 votes 0 votes srestha commented Sep 3, 2019 reply Follow Share @sakharam It is not possible, see here 12.4 http://web.cs.ucla.edu/classes/fall04/cs143/solutions/chap12a.pdf 0 votes 0 votes sakharam commented Sep 4, 2019 reply Follow Share Mam, search key need not be a key(primary key/candidate key), right? Yes mam, I agree about the order thing that generally the order would be different. But I talked about a rare case when order is same. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes https://www.coursehero.com/file/p5gnb2o/124-Is-it-possible-in-general-to-have-two-primary-indices-on-the-same-relation/ sachin486 answered Oct 2, 2020 sachin486 comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Primary indexing is always done on ordered key field,i.e you can order the database file only on one field,right ? That’s why,it is not possible to have 2 primary indexing s_dr_13 answered Nov 11, 2020 s_dr_13 comment Share Follow See all 0 reply Please log in or register to add a comment.