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.

what is 'trigger' in sql? : Sql dba

0 Answers  

---

How many types of triggers are there in pl sql?

0 Answers  

---

how to create user in sql and how to set password for that?

3 Answers  

---

What is the difference between pl and sql?

0 Answers  

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

how can we repair a mysql table? : Sql dba

0 Answers  

---

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

---

What is the difference between rollback and rollback to statements?

0 Answers  

---

Is primary key always clustered index?

0 Answers  

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

Is microsoft sql free?

0 Answers  

---