Explain what partitioning is and what its benefit is.
Answer Posted / guest
Partitioning is a method of taking large tables and indexes
and then splitting them into smaller and more manageable
pieces.
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the default fill factor value? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what is logical system in sap basis
What is the difference between clustered and non-clustered index? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
internal architecture
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what do you understand by flashback feature of oracle?
What are the operating modes in which database mirroring runs? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is grd?
What is dbcc? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?