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.

Can we use ddl statements in stored procedure?

0 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---

What is anonymous block in sql?

0 Answers  

---

what is msql? : Sql dba

0 Answers  

---

What is a merge query?

1 Answers  

---

What is partition in sql query?

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

explain normalization concept? : Sql dba

0 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

What sql database should I use?

0 Answers  

---

What is compilation error in pl sql?

0 Answers  

---