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
- 10725 Views
- Hexaware, I also Faced
- E-Mail Answers
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
Can a view be mutating? If yes, then how?
what are the join types in tsql? : Transact sql
How can we optimize a sql query?
what is a field in a database ? : Sql dba
What is a sql schema used for?
What is the max nvarchar size?
What is the main reason behind using an index?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are the types of join and explain each?
What is the difference between nvl function, ifnull function, and isnull function?
how to use myisamchk to check or repair myisam tables? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
how to drop an existing table in mysql? : Sql dba
How many types of functions are there in sql?
What is the difference between mdf and ndf files?
