We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
|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)
y kia hy??
jo solution yahan py upload howa hy, wo sai hy kiya ? Please koe kuch tw btao
Please Discuss here about this GDB.Thanks
Our main purpose here discussion not just Solution
We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.
I think that the non-cluster model to be used because it give data in blocks so we can make blocks in special criteria or designation.
is it so?
There is only 1 clustered index allowed per table so choose wisely. This index should be the most common column that is in your WHERE clauses for queries against this table. So if most of the time you search by primary key, then leave it as the default. But if you search by DateCreated or LastName most of the time on this table, then you might want to consider changing the clustered index to this column instead.
Some things to remember when using clustered indexes:
There a few things to keep in mind when changing the default clustered index in a table:
Best Practices for Clustered Indexes
Non-clustered indexes are not copies of the table but a sorting of the columns you specify that "point" back to the data pages in the clustered index. This is why the clustered index you choose is so important because if effects all other indexes.
There are 2 modes for non-clustered indexes, Non-unique and unique. Non-Unique means that the index does not act as a constraint on the table and does not prevent identical rows from being inserted. Unique constraints mean that the index prevents any identical rows from being inserted.
Best Practices for Non-clustered Indexes
Indexes are a lot of "trial and error" depending on your database design, SQL queries, and database size.
kia he acha hoota agar aap gdb ka jawab bhe de ddeety
we dont need all this
Waqas explained Clutered Indexes. The purpose of this thread is to discuss, not copy each other's solutions.
My gdb solution file is attach plz check and comments. and plz do not post the same file if u want to post it plz make some changes in the file.
yeh gdb hai ya assgnmnt
gdb to the point hota apn to itnaaaaaaaaaaaaa zada likh dia