Answer / avi007

Hash joins do not use indexes and perform full-table scans
often using parallel query. Hence, the use of hash joins
with parallel full-table scans tend to drive-up CPU
consumption.

Answer / ankush

A hash join is a join optimization method where two tables
are joined based on a hashing algorithm.

Hashing refers to the conversion of a column's primary key
value to a database page number on which the row will be
stored. Retrieval operations that specify the key column
value use the same hashing algorithm and can locate the row
directly. Hashing provides fast retrieval for data that
contains a unique key value.

Note that a hash value cannot be converted back to the
original value.

What is mutating error?

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

0 Answers  

---

What are sql objects?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

How to add, remove, modify users using sql?

0 Answers  

---

Explain what is a subquery ?

0 Answers  

---

Is sql injection illegal?

0 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

can sql servers linked to other servers like oracle? : Sql dba

0 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

What is the process of debugging?

0 Answers  

---