what is the use of HASH, LIST partitions?
Answer Posted / s
A.HASH partitioning is useful on columns which are unique
in nature where range or list partitioning cannot be done.
All the hash partitions hold an equal number of rows
thereby improving the performance and response time of the
query if the table is queried.
List partition is used on a table if you can divide table
based on column value. Something like region wise
partioning if the table contains a column like region.The
advantage of list partitioning is that you can group and
organize unordered and unrelated sets of data in a natural
way.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are sql queries used for?
Explain how can you save or place your msg in a table?
What is the maximum size of sqlite database?
When is the update_statistics command used?
Explain the components of sql?
How to start the command-line sql*plus?
What is execution plan in sql?
what is rdbms? : Sql dba
What is the use of procedures?
What are the disadvantages of not performing database normalization?
What is data type in sql?
Where is pl sql used?
what are null values? : Sql dba
Can we join tables without foreign key?
Show the cursor attributes of pl/sql.