what is the use of HASH, LIST partitions?
- 1 Answers
- 4807 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
What are the packages in pl sql?
What are the parameter modes supported by pl/sql?
where are cookies actually stored on the hard disk? : Sql dba
How to fetch alternate records from a table?
Explain foreign key in sql?
What is the reports view in oracle sql developer?
What is write ahead logging in sql server?
what is rollback? : Sql dba
What is a temporal data type?
Can we use ddl statements in stored procedure?
Is oracle and sql same?
what is the difference between truncate and drop statements? : Sql dba
What is an exception in PL/SQL? What are the two types of exceptions?
What is pl sql variable?
how to fetch alternate records from a table? : Sql dba
