Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of HASH, LIST partitions?
- 1 Answers
- 5367 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
What is a full join?
How is data stored in sql?
What is the difference between microsoft sql and mysql?
Explain locks? : Transact sql
What sql does db2 use?
What is pessimistic concurrency control? : Transact sql
What is difference between nchar and nvarchar?
What will you get by the cursor attribute sql%found?
What is online transaction processing (oltp)?
What is a unique key?
What is cte?
Does sqlite need a server?
Write a sql query to convert all character to uppercase after hypen.
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is the default isolation level in sql server? : Transact sql
