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
- 11315 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
Why is sharding used?
Why stored procedures are faster than query?
Can instead of triggers be used to fire once for each statement on a view?
Is sqlite thread safe?
Can a table have no primary key?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
How to check if a column is nullable before setting to nullable?
How do you delete a table?
Is sql low level language?
How do you update f as m and m as f from the below table testtable?
what is user defined functions? : Sql dba
Is ms sql is free?
What is pl sql block in dbms?
How much does sqlite cost?
Can ddl statements be used in pl/sql?
