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
What is the use of desc in sql?
How can you fetch first 5 characters of the string?
How do I run a script in sql developer?
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...
What is sql query optimization?
What is plpgsql language?
what are the differences between require and include, include_once and require_once? : Sql dba
Is primary key an index?
Can variables be used in sql statements?
What is set transaction?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Do prepared statements prevent sql injection?
What is replication id?
Explain the the update statement in sql?
What normalization means?