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
How to Declare Fixed Length String Value In PL SQL
Is mariadb nosql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
what is foreign key? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
what is sql in mysql? : Sql dba
Does sqlite need a server?
How do I run a script in sql developer?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is dml with example?
What are tables and fields in the database?
How long it takes to learn pl sql?
What is data abstraction in sql?
What are literals in sql server?
What is multiple columns?