Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is the use of HASH, LIST partitions?



what is the use of HASH, LIST partitions?..

Answer / 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

More SQL PLSQL Interview Questions

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,


What are character functions?

0 Answers  


What is not in sql?

0 Answers  


What is database sql?

0 Answers  


what is 'mysqldump'? : Sql dba

0 Answers  






What is the reports view in oracle sql developer?

0 Answers  


Difference between SUBSTR and INSTR?

3 Answers  


How many sql statements are used?

0 Answers  


How do I truncate a sql log file?

0 Answers  


Does view store data in sql?

0 Answers  


Is json a nosql?

0 Answers  


What is the most restrictive isolation level? : Transact sql

0 Answers  


Categories