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
- 11332 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
What is sqlite format?
Can procedure in package be overloaded?
what is the command line end user interface - mysql? : Sql dba
How do you update f as m and m as f from the below table testtable?
What are the most important ddl statements in sql?
What is varchar sql?
How do you write a complex sql query?
what are tables and fields? : Sql dba
What is duration in sql profiler trace?
what is text? : Sql dba
What is a left join?
What is union, minus and interact commands?
Is trigger a stored procedure?
What are sql built in functions?
What are types of exception?
