Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one tell me how to increase the performance of a
sql query ie what are the performance tips in creating or
writing a sql query !!?
- 3 Answers
- 12485 Views
- eBay, I also Faced
- E-Mail Answers
Answer Posted / hutashan
use Inline view to eleminate large number of rows
Avoid implicit datatype conversion
Avoid using function on an indexed column
Avoid comparing column value with NULL
Outer Join
Use OR carefully
Do not use outer join unless absolutely necessary. Degree
of optimizing outer join permutation is VERY LIMITED
Instead: Consider using default values in the base table to
avoid outer join
Do not outer join to a view. This typically results in a
non-mergable view execution plan
Always use NOT EXISTS instead of NOT IN
Remove DISTINCT keyword from SELECT if UNION is used
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is autocommit sql?
tell me about various levels of constraint. : Sql dba
What are crud methods?
What is the command used to fetch the first 5 characters of a string?
What are sql indexes?
How to sort the rows in sql.
Does mysql support pl sql?
what is the difference between undefined value and null value? : Sql dba
what are the different tables present in mysql? : Sql dba
Does db2 use sql?
Can you inner join the same table?
what are date and time data types? : Sql dba
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is a sql profiler?
What is cursor and its types?
