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 / 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 sql not null constraint?
What are the packages in pl sql?
What does select top 1 do in sql?
Is microsoft sql free?
What does where 1/2 mean in sql?
Are left and right joins the same?
What is an example of translating a date into julian format?
Why do we create views in sql?
What are predefined functions in sql?
What is nvarchar max in sql?
How to run sql functions in pl/sql?
how many triggers are allowed in mysql table? : Sql dba
what is a trigger in mysql? Define different types of trigger. : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is serial sql?