Interested to Buy Any Domain ? << Click Here >> for more details...
How do you optimize SQL queries ?
- 6 Answers
- 36104 Views
- CarrizalSoft Technologies, Infosys, Oracle, I also Faced
- E-Mail Answers
Answer Posted / rupa
Most often, Databases have bad designs and are not
normalized. This can greatly affect the speed of your
Database. As a general case, learn the 3 Normal Forms and
apply them at all times. The normal forms above 3rd Normal
Form are often called de-normalization forms but what this
really means is that they break some rules to make the
Database faster.
What I suggest is to stick to the 3rd normal form except if
you are a DBA (which means you know subsequent forms and
know what you're doing). Normalization after the 3rd NF is
often done at a later time, not during design.
for more information go Through below link
http://www.serverwatch.com/tutorials/article.php/2175621
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What does select * from mean in sql?
How do I view a view in sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How to run sql commands in sql*plus?
What are the ways on commenting in a pl/sql code?
What is meaning of <> in sql?
How many times can we commit in a loop?
What is db journal file?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Can a view be mutating? If yes, then how?
What is the difference between microsoft access and sql?
What is offset in sql query?
Explain raise_application_error.
How delete a row in sql?
