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.
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 sql procedures and functions?
Can we alter stored procedure?
How to rename a table?
What is meant by truncate in sql?
What is multiple partition?
What is the requirement of self-join?
How many types of normalization are there?
How do I kill a query in postgresql?
How much ram can sql express use?
How does one load ebcdic data? : aql loader
what is the syntax for using sql_variant_property? : Transact sql
How does sql profiler work?
What are the uses of sysdate and user keywords?
What is pl sql collection?
Define join and name different types of joins?