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
What is a primary key sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Define select, insert, create, delete, update, drop keywords
What is the difference between delete and truncate commands?
Which kind of parameters cannot have a default value in pl sql?
Which is faster union or join?
Can delete statement be rollbacked?
How do I count rows in sql query?
what are all the different normalizations? : Sql dba
Which is better stored procedure or query?
What is sqlexception in java?
How do I install sql?
How do I remove duplicates in two columns?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is asqueryable?