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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the drivers in mysql? : Sql dba

549


What are the sql aggregate functions?

602


What are the parameter modes supported by pl/sql?

528


What is package in pl sql with an examples?

539


What are the differences between implicit and explicit cursors?

513






How to use sql statements in pl/sql?

576


What are aggregate and scalar functions?

521


What are the types of records?

524


What is a database event trigger?

581


what are the differences between char and varchar? : Sql dba

519


Can we insert data in view?

497


What is difference between stored procedure and trigger?

527


What is a constraint? Tell me about its various levels.

634


Does a user_objects view have an entry for a trigger?

568


What is the difference between left and left outer join?

508