SQL -- some caveats (continuously updated)

Recommended for you: Get network issues from WhatsUp Gold. Not end users.
  1. TRUNCATE Only full table, no WHERE Sentence
  2. rownum <N cannot and group by Used together
  3. NULL usually limit index. When you create a table for a specified NOT NULL Or DEFAULT , To avoid performance problems may be helpful.
  4. The query is the key in the system, can be created in the SELECT and WHERE clauses are listed on theCombined index, This can only access the index.
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Yale at December 05, 2013 - 9:23 PM