Intermediate SQL Color Coded SQL, UNIX and Database Essays

Twitter: @intermediatesql

• Validate constraint in PARALLEL: alter table PARALLEL + alter table ENABLE VALIDATE constraint 01:35:54 AM June 26, 2011 from web ReplyRetweetFavorite
• You can active duplicate from physical STANDBY database, if you set state=APPLY-OFF on standby 12:57:34 AM May 08, 2011 from web ReplyRetweetFavorite
• Golden rule of PAGINATION INDEXING - Either "fix" leftmost columns (c=v) OR include them in ORDER BY 08:39:27 PM April 21, 2011 from web ReplyRetweetFavorite
• Golden rule of PARTITIONING - If you can't make 99% of your SQLs hit a single partition -> don't do it ! 08:37:15 PM April 21, 2011 from web ReplyRetweetFavorite
• dba_sql_plan_baselines.signature = v$sql.force_matching_signature 01:53:13 AM March 10, 2011 from web ReplyRetweetFavorite