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 is cursor. write example of it. What are the attributes of cursor.
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
What is the usage of distinct keyword?
If the base table structure is changed what will happen to join index????
What can sql server reporting services do?
How can we optimize a sql query?
What is the difference between join and natural join?
What is difference between db2 and sql?
Does sql*plus have a pl/sql engine?
How do you display "13th of November, 17 days left for month end" without hardcoding the date.
What are sql triggers used for?
What are string functions in sql?