what is the use of HASH, LIST partitions?

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


Please Help Members By Posting Answers For Below Questions

What is the use of desc in sql?

473


How can you fetch first 5 characters of the string?

528


How do I run a script in sql developer?

472


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

1885


What is sql query optimization?

525






What is plpgsql language?

504


what are the differences between require and include, include_once and require_once? : Sql dba

496


Is primary key an index?

516


Can variables be used in sql statements?

531


What is set transaction?

557


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

599


Do prepared statements prevent sql injection?

498


What is replication id?

497


Explain the the update statement in sql?

546


What normalization means?

502