Answer / neetu

U have to optimize SP for that
1. Use as much as possible WHERE clause filters. Where
Clause is the most important part for optimization
2. Select only those fields which really require.
3. Joins are expensive in terms of time. Make sure that use
all the keys that relate the two tables together and don't
join to unused tables, always try to join on indexed fields.
The join type is important as well (INNER, OUTER).

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

---

What are the properties of sub-query?

0 Answers  

---

What is postgresql server?

0 Answers  

---

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

What is a system database and what is a user database?

0 Answers  

---

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

What is the purpose of grouping data in a report?

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

What is an example of a primary key?

0 Answers  

---