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
- 12289 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
differentiate between float and double. : Sql dba
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
When is the update_statistics command used?
Can 2 queries be executed simultaneously in a distributed database system?
Why is %isopen always false for an implicit cursor?
What is the main difference between sql and pl/sql?
What is oracle sql developer?
What does count (*) do in sql?
How can we solve sql error: ora-00904: invalid identifier?
What is union and union all keyword in sql and what are their differences?
Which sql statement is used to return only different values?
write an sql query to find names of employee start with 'a'? : Sql dba
Why do we use joins in sql?
What is difference between joins and union?
What is primary key and foreign key?
