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
- 11928 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
Can a table contain multiple primary key’s?
What is the difference between local variables and global variables?
What is java sql drivermanager?
What are the most important ddl statements in sql?
What do you mean by field in sql?
What is the cause of mutating table error and how can we solve it?
What is the source code of a program?
What is form and report?
Can we join same table in sql?
What is the syntax to add a record to a table?
Are stored procedures faster than queries?
How do I run a query in pl sql developer?
what is self-join? : Sql dba
what does myisamchk do? : Sql dba
What is a composite primary key?
