Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of HASH, LIST partitions?
- 1 Answers
- 5254 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
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is a left inner join?
Can we rollback after truncate?
what is acid property in database? : Sql dba
What is the difference between explicit and implicit cursors in oracle?
How do I install sql?
What is sqlca in powerbuilder?
What are operators available in sql?
What is java sql driver?
What are the types of variables use in pl sql?
How do I add a database to sql?
Is sql scripting language?
How to execute a stored procedure?
explain primary keys and auto increment fields in mysql : sql dba
what are all the different normalizations? : Sql dba
