What is the first action to perform a query? Suppose I have four tables and fiv

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.

Question Posted / useroracle

4 Answers
10757 Views
Hexaware, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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.

Is This Answer Correct ?

7 Yes

1 No

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

Answer / vaibhavi_dixit

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

VD

Is This Answer Correct ?

6 Yes

0 No

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

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

Is This Answer Correct ?

2 Yes

0 No

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

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.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer