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
- 12109 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 we insert in view in sql?
Explain how to use transactions efficiently : transact sql
What are sql*plus environment variables?
Which constraints we can use while creating database in sql?
Explain what is a view?
How to select all records from the table?
where are cookies actually stored on the hard disk? : Sql dba
What is the use of function "module procedure" in pl/sql?
what is data manipulation language? : Sql dba
How do you rename a table in sql?
Is pl sql still used?
What does select * from mean in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is plpgsql language?
What is scope of pl sql developer in future?
