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
- 11930 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
How many sql statements are used?
When is a declare statement required?
What is the difference between rollback and rollback to statements?
What are the different operators available in sql?
What is the purpose of design view?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What makes a good primary key?
What will you get by the cursor attribute sql%found?
what is a trigger in mysql? : Sql dba
What is a database trigger?
Explain the select statement in sql?
What is dml with example?
what are date and time data types in mysql? : Sql dba
What is meant by truncate in sql?
What is a nested table in word?
