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
12139 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

More SQL PLSQL Interview Questions

What is pl sql in oracle?

0 Answers

What are advantages of Stored Procedures?

3 Answers Satyam,

What is a loop in sql?

0 Answers

Are pl sql variables case sensitive?

0 Answers

What is the use of sqlerrd 3?

0 Answers

Types of optimization?

6 Answers Microsoft,

What is sorting in sql?

0 Answers

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers 3i Infotech,

What is difference between a PROCEDURE & FUNCTION ?

6 Answers Satyam,

What is the purpose of the partition table?

0 Answers

What is use of trigger?

0 Answers

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers TCS,

For more SQL PLSQL Interview Questions Click Here