Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12110 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Which is better cte or subquery?
what are dynamic queries in t-sql? : Transact sql
Why is there a need for sqlcode and sqlerrm variables?
What is auto increment?
What is t sql used for?
Why coalesce is used in sql?
what are set operators in sql? : Sql dba
Can we use insert statement in function?
what is bcp? When does it used? : Sql dba
Can we use threading in pl/sql?
Can we join tables without foreign key?
Will truncate release space?
What are stored procedures used for?
what is meant by urlencode and urldocode? : Sql dba
What is the difference between subquery and correlated query?
