Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of HASH, LIST partitions?
- 1 Answers
- 5236 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
Explain what is table in a database?
In what condition is it good to disable a trigger?
What are the disadvantages of file system?
what is a join? : Sql dba
How can we store rows in PL/SQL using array?
what is the use of double ampersand (&&) in sql queries?
What are primary key and foreign key and how they work?
Compare sql & pl/sql
what is union, minus and interact commands? : Sql dba
what is sp_pkeys? : Transact sql
What is a schema? How is it useful in sql servers?
Why function is used in sql?
What is use of trigger?
What is a join query?
how to dump a table to a file with 'mysqldump'? : Sql dba
