Answer / rahul khanke

in any joins (n-1)where n is no of tables is the criteia if
u have four table then there are 3 joins use it.

Answer / vaibhavi_dixit

Also check that the tables does not have more NULL values,
which also reduces the performance.

VD

Answer / sandeep t

the best way is to create another table by writing a
procedure . In the procedure create a temp table and then
populate the table which created with all the
conditions.You can use the newly created table to satisfy
all the conditions by this you could avoid creating load on
the database

Answer / avi007

check the how many indexes created on join column of
tables, check the join which has been done on common column
of both tables.

How do you rank data in sql?

0 Answers  

---

Why do we need unique key in a table?

0 Answers  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

How to run sql statements through the web interface?

0 Answers  

---

give the syntax of grant and revoke commands? : Sql dba

0 Answers  

---

---

What is a stored procedure ?

5 Answers  

---

What is auto increment feature in sql?

0 Answers  

---

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

---

What does sign mean sql?

0 Answers  

---

What is difference between table and view?

0 Answers  

---