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
- 12302 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
How do you update f as m and m as f from the below table testtable?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is secondary key?
How global cursor can be declare with dynamic trigger ?
What is rtm stands for?
how can we submit a form without a submit button? : Sql dba
what is data integrity? : Sql dba
What is the non-clustered index in sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Can we create foreign key without primary key?
Is it possible to sort a column using a column alias?
What is parameter substitution in sql?
Explain the the delete statements in sql?
What is difference between nchar and nvarchar?
Is sql a oracle?
