Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of HASH, LIST partitions?
- 1 Answers
- 5443 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
How do I start sql profiler?
How do I run a sql script?
Write a sql select query that only returns each name only once from a table?
how mysql optimizes distinct? : Sql dba
What is sqlerrm?
what is a table in a database ? : Sql dba
What is dense_rank in sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is a column in a table?
Define join and name different types of joins?
What is rank dense_rank and partition in sql?
What is primary key and unique key?
Which table is left in left join?
How do you use join?
what are the types of join and explain each? : Sql dba
