We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
Suppose we have a table “Employee” having column “age” in it. The table “employee” might have a data of different age groups according to their designations. The employee at high levels of post like Project Manager, Managing director etc has different age group when we are comparing it with other junior or senior level employees.
You have studied various indexing techniques for random access and better organization of data. By having a context of above scenario; if you have given an option to choose one indexing technique from two below indexes, which you would like to choose that will help to get optimized results?
§ Clustered index
§ Un-clustered/Non-clustered index
You have to choose only one technique out of the two and give valid reasons to support your answer.
Note: Try to provide precise, to the point answer and avoid irrelevant details.
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
post ur gdb and then see result
ye kia h koi kuch kh rha koi kuch bnda suny kis kiii???
ksi ki b nhi... suno sb ki karo apni
Dear your gdb solution needs your 3 mnts. just listen to the lecture 39 (17mnt to 20th mnts)
dakh liya sun b liya but kuch khas hint nhn ha
bhaio medan e jang mat bnao es ka solution nikalo jald, its getting late
agr indexing use he nhi krni to question q dia gya k chose one indexing technique????????????
sary bchy confuse kri ja rhy plz koi solution b btay ga?
significant variety in values
is scenerio me humry pas age ki 3 values aati hen u can ay boy(junior), young(senior) and mature(director). We will get lot of records with one value in this case. oracle k mutabiq index banany k liay at least ek he attributre ki 30 different values honi chahye. agr kam hon gi tu hmary tree k kam nodes banty hen aur pointers ki tadad bohat barh jati ha.
if u guys listen to the lecture's portion I told u, u can find solution in no time.
when we working on data base then we want data from table in physical form Cluster Index is all base on their working physically but
Un-clustered/Non-clustered index are use logically ways and data style.
Answer is Cluster Index because we find data in physical from not logical
kya he acha gdb friends ek to instructor nay mind ko ghuma dea ab ap log aur bhi complicated kar rahy ho kindly koi hint day ga k which one is best or we select both index :(
cluster index is the best is ko define kr do ok