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
- 10791 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
What is nosql db?
How do I create a sql database?
What are predefined functions in sql?
When should I use nosql database?
What is sql scripting?
What are the possible values that can be stored in a boolean data field?
what tools available for managing mysql server? : Sql dba
What are the types of variable use in pl sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is nosql vs sql?
Is natural join same as inner join?
Define union, minus, union all, intersect ?
what are dynamic queries in t-sql? : Transact sql
Why procedure is used in sql?
What is query execution plan in sql?
