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


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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

lekin scenario mn "different age groups according to their destination" kha gya ha

its a cluster index

koi tu sahe solution bata do................

koi ty solution dy do bhai

yar ap sab aven khap rahay ho jinhon nay kar liya hae woh so gaye hun gaye aram say 

jo bhi samjh ata hae likh do dostooooo 

yes i hv done my gdb

Rubab shear hi kar daen  plz

cluster kia ha ma ne

due to just age column

dae daen ma nae b abi karna hay ...

I would like to choose cluster index because the data is huge and in case of sorting and searching of data in indexed situation the time of sorting is large In cluster index i can group all the related data into one group e.g. at least equal age group join together and set them one primary key for one cluster so that in case of searching only that sort of group searched which contain equal or near to primary key.

RSS

Latest Activity

+Mr President updated their profile
8 minutes ago
A_Q added a discussion to the group ENG513 Language Teaching Methods
27 minutes ago
ALEENA replied to + M.Tariq Malik's discussion Site Overview | Assignment Solutions | Past Papers Solutions | VU Students Features
28 minutes ago
+ !! "AS" !! replied to + !! "AS" !!'s discussion Ghalti...
31 minutes ago
Profile IconALI RAZA, Husnain Kan, Safdar Mehmood and 25 more joined Virtual University of Pakistan
34 minutes ago
ALEENA liked + Iuuoɔǝut +'s discussion MTH401_Mid term Solved (Part I) with refrence
35 minutes ago
Shine--Ex-VUStudent liked + !! "AS" !!'s discussion Yaha Har Cheez ..
37 minutes ago
Shine--Ex-VUStudent liked +¢αяєℓєѕѕ gιяℓ's discussion Iss tasvir ko Unwan Dein :-P
39 minutes ago
ALEENA replied to ٥ دن's discussion Gunahon ki gehrai
40 minutes ago
ALEENA replied to + !! "AS" !!'s discussion Ghalti...
42 minutes ago
ALEENA replied to Siddiq khan kakar's discussion RIP
44 minutes ago
Muhammad Hamza Mehmood liked Faiza's profile
46 minutes ago
Profile IconKhan and zuha shah joined + M.Tariq Malik's group
46 minutes ago
Khan joined + M.Tariq Malik's group
47 minutes ago
Profile IconKhan and sardarni joined + M.Tariq Malik's group
49 minutes ago
ALEENA replied to +¢αяєℓєѕѕ gιяℓ's discussion Iss tasvir ko Unwan Dein :-P
52 minutes ago
zuha shah joined + M.Tariq Malik's group
53 minutes ago
zuha shah liked + M.Tariq Malik's group PSY401 Clinical Psychology
54 minutes ago
zuha shah liked + M.Tariq Malik's group MGT111 Introduction to Public Administration
54 minutes ago
Ali joined + M.Tariq Malik's group
56 minutes ago

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

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