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
- 10965 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 index example?
What is the difference between execution of triggers and stored procedures?
What is difference between stored function and application function?
What is the mutating table and constraining table?
What is information schema in sql?
how to shut down the server with 'mysqladmin'? : Sql dba
What is a unique key?
Is oracel sql developer written in java?
What is cursor and why it is required?
Differentiate between pl/sql and sql?
i have some prob lem to tell me about my self in interview first round ...
What is vector point function?
what is the difference between inner and outer join? Explain with example. : Sql dba
How do you optimize a stored procedure in sql?
Which nosql database is best?
