Interested to Buy Any Domain ? << Click Here >> for more details...
How do you optimize SQL queries ?
- 6 Answers
- 35583 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
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is the difference between row level and statement level trigger?
Can we update views in sql?
What is the usage of when clause in trigger?
what is the difference between char and varchar data types? : Sql dba
Why do we need a foreign key?
can sql servers linked to other servers like oracle? : Sql dba
Can you call pl/sql package functions from within a fast formula?
what are all the common sql function? : Sql dba
Where is pl sql used?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is trigger in sql and its types?
What is the difference between the conventional and direct path loader? : aql loader
How do you use a while loop in pl sql?
What is delete command in sql?
