Obtaining indexes on a table can increase concurrency, as well as decreas the time needed to access the table. Explain why.
What will be an ideal response?
If index locking is used and the table is accessed through the index, the entire table need not be locked but only the index (in addition to obtaining an intention lock on the table).
Computer Science & Information Technology
You might also like to view...
The Find option on the Select Browse Object menu is used to move to the next word or phrase that has been typed into the Find and Replace Dialog box
Indicate whether the statement is true or false
Computer Science & Information Technology
Programs that you use frequently are known as ____ items.
A. personal library B. user account C. taskbar D. pinned
Computer Science & Information Technology