Explain why a table might be partitioned in the schema of a centralized system.

What will be an ideal response?


If di?erent applications or di?erent transactions in the same application need to access di?erent parts of a table, the table might be partitioned so that these parts are in di?erent partitions. This might have the e?ect of speeding up the applications, since a
transaction need not obtain any locks on the partitions it does not access.

Computer Science & Information Technology

You might also like to view...

Can a class implement two interfaces that each contains the same method sig-nature? Explain.

What will be an ideal response?What will be an ideal response?

Computer Science & Information Technology

You can select an entire table by clicking the ________ button in the document

A) Edit Table B) Format Table C) Select All D) Select Table

Computer Science & Information Technology

Under the "No Harm, No Foul" approach, even if a person adversely affects the others around him, there is no need to punish that person.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The MigApp.xml file contains rules for migrating application settings

Indicate whether the statement is true or false

Computer Science & Information Technology