Explain what partitioning is and what its benefit is.
- 2 Answers
- 6782 Views
- I also Faced
- E-Mail Answers
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 are the commands used in dcl? : sql server DBA
Why would you use sql agent? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
what is asm?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the different sql server versions you have worked on? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What would you do with an "in-doubt" distributed transaction?
what are the benefits of flashback feature?
