what is the use of HASH, LIST partitions?
Answer / 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 |
What port does sql server use?
can we call a procedure from a function?
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
What does plv msg allows you to do?
What is varchar sql?
what is self join and what is the requirement of self join? : Sql dba
write a procedure to find top second no from a list of numbers
Difference between inline query and stored procedure?
What is the difference between sql and isql*plus?
Where the integrity constrints are stored in Data Dictionary?
What is Difference Between delete and Truncate?
Does execute immediate commit?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)