Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Format EXPLAIN PLAN results easily with Oracle's DBMS_XPLAN
- When you need to troubleshoot inefficient SQL, one of the most important diagnostics tools at your disposal is the output of the EXPLAIN PLAN command. Find out how Oracle's DBMS_XPLAN functions can help you tune your SQL statements. One of the most important diagnostic tools in troubleshooting inefficient...
- Tags: Oracle Corp., SQL, DBMS_XPLAN.DISPLAY, Databases, Bob Watkins, Programming languages, execution plan, Explain Plan, SQL Statement, PLAN_TABLE, DBMS_XPLAN, Oracle Tips Newsletter, Listing B, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2006-05-16
Additional Resources
- unix query
- delete from plan_table; Explain plan SET statement_id='XXX' FORSELECT COUNT(*)FROM po_distb_promo pdp, po_distb pd, batch_cntl bc, appt_po apWHERE bc.batch_i='36496568'AND ap.appt_i=bc.appt_iAND pd.po_i=ap.po_iAND pd.dept_i=bc.dept_iAND pd.class_i=bc.class_iAND pd.item_i=bc.item_iAND pd.po_distb_i=pdp.po_distb_i; column operation format a16column options format a15column object_name format a20column id format 99select lpad(' ',2*(level-1))||operation||' '||options||' '||object_name||' '|| ...
- Tags: Unix, abhigoel_208@..., XXX, id
- Discussion threads 2007-05-15
- Oracle Tip: Understand the difference between IN and EXISTS in subqueries
- When using rule-based optimization, you can determine the performance of a rule-based query by understanding which table is the driving table and how many rows each part returns. Find out how with this hands-on solution. When coding a SQL statement with tables in master-detail relationships, it's common to...
- Tags: Scott Stephens, Oracle Tips Newsletter, Oracle Corp., Query, KING, Performance Management, Databases, Human Resources, Workforce Management, Enterprise Software, Software, Data Management
- Technical articles 2004-08-04
- New Oracle10g SQL optimizer hints
- With each new release of Oracle, there are more tuning controls and opportunities for improving the execution speed of SQL. In an article about speeding up SQL execution in Oracle, I discussed some common SQL tuning hints and, in another article, I warned about performance issues when using SQL hints...
- Tags: PRODUCTIVITY, Databases, Donald Burleson, specified table
- Technical articles 2004-04-26
- << Previous
- page 1 of 1
- Next >>
