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 fill factor? : sql server DBA
What is a correlated sub-query? : sql server DBA
what is the diffrence between core dba and apps dba?
What would you do with an "in-doubt" distributed transaction?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
when does an alert gets signaled?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what are the benefits of flashback feature?
Why does Oracle not permit the use of PCTUSED with indexes?
What the different components in replication and what is their use? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what is asm?