We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
+ Link For Assignments, GDBs & Online Quizzes Solution
+ 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.
|GDB||Dated: Aug 06, 15|
Note that the Graded Discussion Board (GDB) of CS403 Database Management Systems will remain open for Two days (48 Hours only) from 12:00 AM August 12th, 2015 (Wednesday) to August 13th, 2015 (Thursday) till 11:59 PM according to Pakistan Standard Time.
The topic of Graded Discussion Board:
Orchid Textile is a large scale organization consisting of hundreds of employees in different office branches across country. HR department decided some new benefits and bonus policies according to pay scale and Designation of employees. So they need to update employees’ relevant record based on specific criteria. Which indexing technique will be better for above scenario for updation of records?
1) Clustered Indexing
2) Non- Clustered Indexing
Justify your answer with proper reasoning.
Note: Try to provide precise (4 to 5 lines only including solid reasons), to the point answer and avoid irrelevant details
For any query: CS403@vu.edu.pk
.+ 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)
According to the given scenario. Non-Clustered indexing is best. In Clustered Indexing we can efficiently ordered the data on the basis of First name or the Last name but we can not modified the data efficiently.
But in Non-Clustered indexing we can ordered the data also we can modified the data efficiently . Because, in Non-Clustered indexing the order of data logically and physically not same.
So, It is best to use Non-Clustered indexing according to the given scenario.
yes got the point
final is non cluster is best for updation
why do you think clustered is not the right choice?
see given scenrio accourding the updation point of view
can you quote the lines or where it's written in detail that non-clustered is better for updating?
non clustered are much slower search for thousands of hundreds of records in a database. you can user apply composite cluster to combine designation and salary fields in desired order for quick search and update.
in non clustered index data is stored in two separate places. like textbook indexes which refer the address of the real data. which are much slower then the real clustered index where data is phisically stored in database. remember every table create automatically an index for the primary key in SQL server databa.se
ki musibat vay
sir dard laag gayi hai
Kindly guide me if i am wrong that the only problem stated by most students, "Updation is the time taking process in Clustered Index and so is not good for heavy data"
For such type of problem, there is a solution available in clustered index that is creation of primary keys or foreign keys. where assigned such values which are less likely to be changed.
Now if u concentrate on our GDB, what it says? I think only updation is required "one Arear" filed which will decide bonus related to other benefits of the employees.
Plz comments over it.
Non Clustered Index
Both types of index will improve performance when select data with fields that use the index but will slow down update and insert operations.
Because of the slower insert and update clustered indexes should be set on a field that is normally incremental ie Id or Timestamp.
you wrong bro..
in this GDB, our primary key is not going to be change that certainly would be Employee Name or ID. So no new addition of row in the data. If Bonus and Incentives take place a new table and we allot them a primary and then connect these two tables, i mean Employee Table (already exist) and Bonus Table (updated material) then Clustered Index would be the best option to execute SQL searching and update criteria.