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
- 12134 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is trigger a stored procedure?
what are enums used for in mysql? : Sql dba
Do prepared statements prevent sql injection?
What is a sql driver?
How to convert comma separated string to array in pl/sql?
Which is faster count (*) or count 1?
What are the advantages of indexing?
How can we solve sql error: ora-00904: invalid identifier?
How do I debug a stored procedure?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
what is acid property in database? : Sql dba
what is query cache in mysql? : Sql dba
How do I partition a table in sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is an escape character in sql?
