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 |
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query
What is sql profiling in oracle?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is hibernate and its relation to sql?
How do you retrieve the last N records from a table?
What is rank function in sql?
What are triggers and its uses?
What is sql performance tuning?
Explain what is rdbms?
what tools available for managing mysql server? : Sql dba
Are subqueries faster than joins?
How to change the order of columns in Oracle SQL Plus ?