We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Question:

 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.

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 9141

.

+ 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)

Replies to This Discussion

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 

RSS

Latest Activity

M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
2 minutes ago
°`·("آفروز") aFFrOzE·´° replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
24 minutes ago
Profile Icon°`·("آفروز") aFFrOzE·´°, Aamir Abbas and Rizwan Ali joined + M.Tariq Malik's group
24 minutes ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
25 minutes ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
26 minutes ago
Ammara commented on + M.Tariq Malik's group MTH501 Linear Algebra
35 minutes ago
Ammara joined + M.Tariq Malik's group
36 minutes ago
+ Haxan updated their profile
55 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" posted a discussion
1 hour ago
Fojjiii updated their profile
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion ENG101 English Comprehension Online Quiz No 01 Fall 2019 Solution Discussion Last Date: 14-11-2019 in the group ENG101 English Comprehension
1 hour ago
Aamir Abbas replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT602 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group MGT602 Entrepreneurship
1 hour ago
+ Iuuoɔǝut + posted videos
1 hour ago
+ M.Tariq Malik is now friends with Careerz360, Sabir Hussain, Gulzar Ahmed and 11 more
1 hour ago
+ M.Tariq Malik left a comment for Muhammad Shahid Javed
1 hour ago
MUHAMMAD USMAN replied to Usman Mughal's discussion Fall 2019 Assignment No. 1 English Comprehension (Eng101) in the group ENG101 English Comprehension
1 hour ago
Profile IconMUHAMMAD USMAN and + ! ! ! ! Mehαr Mαh꧂ joined + M.Tariq Malik's group
1 hour ago
+ M.Tariq Malik replied to Usman Mughal's discussion ENG201 QUIZ 1 date 13 to 14 November in the group ENG201 Business and Technical English Writing
1 hour ago
+ M.Tariq Malik replied to Usman Mughal's discussion ENG201 QUIZ 1 date 13 to 14 November in the group ENG201 Business and Technical English Writing
1 hour ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service