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 / 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
What is the use of pl/sql table?
What is assignment operator in pl sql?
what is isam? : Sql dba
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How many sectors are in a partition?
What is sqlca in db2?
How to handle bulk data?
Define commit, rollback and savepoint?
How to read/write files from pl/sql?
Does a user_objects view have an entry for a trigger?
Can we call a function containing dml statements in a select query?
Why commit is not used in triggers?
What is raid? How does it help storage of databases?
What does a pl/sql package consist of?
How many types of functions are there in sql?