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
- 10732 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / vaibhavi_dixit
Also check that the tables does not have more NULL values,
which also reduces the performance.
VD
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How do you bind variables in pl sql?
What is bulk collect in pl sql?
what tools available for managing mysql server? : Sql dba
what are rollup and cube in t-sql? : Transact sql
what are different types of collation sensitivity? : Sql dba
What is the use of function in sql?
Can you load data into multiple tables at once? : aql loader
What does the base_object_type column shows in the user.triggers data dictionary view?
What is group function in sql?
Is hadoop a nosql?
what is a trigger? : Sql dba
What are field types?
Is sql better than excel?
What is sql scripting?
State some properties of relational databases?
