Home E-mail Us Oracle Articles New Oracle Articles
|
SQL Tuning Cheat sheet
| |||
|
- Oracle SQL Tuning Quick Reference cheatsheet. Oracle Database Tips by Donald BurlesonFebruary 21, 2015. SQL Tuning Cheat sheet by Donald K.
- SQL set timing on SQL set autotrace on SQL explain plan for select blah. Index Statistics. Check the time table statistics were last updated. Select tablename, lastanalyzed from usertables. Check the time index statistics were last updated. Select indexname, lastanalyzed from userindexes.
- SQL AGGREGATE FUNCTIONS AVG returns the average of a list CREATE TEMPORARY VIEW v AS SELECT c1, c2 FROM t; Create a temporary view WHEN. BEFORE –invoke before the event occurs. AFTER –invoke after the event occurs EVENT. INSERT –invoke for INSERT. UPDATE –invoke for UPDATE. DELETE –invoke for DELETE TRIGGERTYPE. FOR.
The SQL cheat sheet commands can be used in any IDE or tool where the user has connected to the database using the JAR file of the database type. The different databases existing in the market are Oracle, Microsoft SQL Server, IBM DB2, etc., which all these can be connected to by using their respective jars and tools to manage the data operations. Oracle 12c For Dummies Cheat Sheet By Chris Ruel, Michael Wessler Knowing the most common tasks an Oracle Database Administrator (DBA) encounters and what a DBA needs to monitor daily can help keep your database running and well-maintained. Master your common command-line executables to develop your DBA expertise.