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
- 12301 Views
- Hexaware, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul khanke
in any joins (n-1)where n is no of tables is the criteia if
u have four table then there are 3 joins use it.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Answer / sandeep t
the best way is to create another table by writing a
procedure . In the procedure create a temp table and then
populate the table which created with all the
conditions.You can use the newly created table to satisfy
all the conditions by this you could avoid creating load on
the database
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What are the benefits of pl/sql packages?
What is a trigger in pl/sql?
can i create trigger on synonym is it possible or not please help me
What is the need of a partition key?
What is a behavioral trigger?
PL/SQL allocates memory for the variable's at runtime or at compile time
What is the difference between the implicit and explicit cursors?
How do I sort a table in sql?
What is pl sql record in oracle?
What is trigger types in sql?
What does over partition by mean in sql?
What is sql comments?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
