Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of HASH, LIST partitions?
- 1 Answers
- 5338 Views
- ITC Infotech, I also Faced
- E-Mail Answers
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
Is keyword pl sql?
how to rename an existing column in a table? : Sql dba
how can we submit a form without a submit button? : Sql dba
What are sql functions? Describe in brief different types of sql functions?
what is schema? : Sql dba
In a distributed database system, can we execute two queries simultaneously?
what is not null constraint? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
How does sql profiler work?
Is pl sql different from sql?
What is normalization in sql?
Which table is left in left join?
Are stored procedures faster than dynamic sql?
what is the use of friend function? : Sql dba
explain commit and rollback in mysql : sql dba
