Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of HASH, LIST partitions?
- 1 Answers
- 5350 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 built in functions of sql?
What are the different types of triggers?
What are the types of join in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is on delete restrict?
What is sql clause?
How to run sql*plus commands in sql developer?
What is an ndf file?
What is raw datatype in sql?
How much does a sql dba make? : SQL DBA
Does pl sql work in mysql?
Explain what is dbms?
what are ddl statements in mysql? : Sql dba
What trigger means?
What is difference between rank () row_number () and dense_rank () in sql?
