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
How to rename a table?
What is a database? Explain
Why do we go for stored procedures?
Define the select into statement.
What is sap sql?
Is the primary key an index?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is clause?
What are the disadvantages of file system?
Is postgresql a server?
How do I audit the sql sent to the server?
How do I find sql profiler?
Is sql open source?
Which is better trigger or stored procedure?
Can we insert in sql function?