Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Database Optimization: Tweaking Oracle SQL performance parameters
- Oracle Corporation has invested millions of dollars in making the cost-based SQL optimizer CBO one of the most sophisticated tools ever created. The job of the CBO is to always choose the most optimal execution plan for any SQL statement.However, there are some things that the CBO cannot detect, which...
- Tags: Programming languages, Databases, performance, database, Donald Burleson, optimizer_index_cost_adj, CBO, Oracle Corp., full-table scan
- Technical articles 2004-01-26
- Track CPU and I/O cost with Oracle9i
- With each new release of Oracle, the database becomes more aware if its external environment. Oracle sets several important initialization parameters based on the number of CPUs on the Oracle server, and Oracle is now becoming more aware of the costs of CPU cycles and I/O operations.The cost-based SQL optimizer...
- Tags: Processors, Databases, Oracle9i, Oracle CBO, Donald Burleson, Oracle Corp., CPU, CBO, I/O
- Technical articles 2003-09-02
- Cost Control: Inside the Oracle Optimizer
- Oracle's Cost-Based SQL Optimizer CBO is an extremely sophisticated component of Oracle that governs the execution for every Oracle query. The CBO has evolved into one of the world's most sophisticated software components, and it has the challenging job of evaluating any SQL statement and generating the "Best" execution plan...
- Tags: Oracle Corp., Cost Control, CBO, Tools & Techniques, Financial Services, Programming Languages, Management, Software Development, Software/Web Development
- White papers
Additional Resources
- Migrating to the Cost-Based Optimizer
- In Oracle Database 10g, only one query optimizer is supported: the Cost-Based Optimizer CBO. Oracle's legacy optimizer, the Rule-Based Optimizer RBO, is no longer supported. While the majority of applications running on Oracle today use the CBO, some applications continue to use the RBO. This paper describes the steps in...
- Tags: Oracle Corp., Databases, Enterprise Software, Software, Data Management
- White papers 2005-04-01
- Upgrading From Oracle Database 9i to 10g: What to Expect From the Optimizer
- Since its introduction in Oracle 7.0, people have been fascinated and intimidated by the Cost-Based Optimizer CBO and the statistics that feed it. It has long been felt that the internals of the CBO were shrouded in mystery and that a degree in wizardry was needed to work with it....
- Tags: Oracle Corp., Oracle9i, Oracle Database, Databases, Enterprise Software, Storage, Software, Data Management, Hardware
- White papers 2008-02-01
- Understanding Optimization
- Since its introduction in Oracle7, the Cost-Based Optimizer CBO has become more valuable and relevant with each new release of the Oracle database while its counterpart, the Rule-Based Optimizer RBO, has become increasingly less so. The difference between the two optimizers is relatively clear: The CBO chooses the best path...
- Tags: Oracle Corp., Optimization, Oracle Database, Databases, Enterprise Software, Software, Data Management
- White papers 2005-01-01
- Um excuse me! Helloooo?
- There seems to be a wee problem with posts.When you try and EDIT a post, which I do for EVERY post, you can't edit it and click submit. It ORDERS you to add tags, FAIR ENOUGH. The problem is, there's no box to add tags to? So...
- Tags: Oz_Media
- Discussion threads 2005-06-30
- Achieve faster SQL performance with dbms_stats
- When a SQL statement is executed, the database must convert the query into an execution plan and choose the best way to retrieve the data. For Oracle, each SQL query has many choices for execution plans, including which index to use to retrieve table row, what order in which to...
- Tags: Programming languages, Databases, Donald Burleson, Oracle Corp., execution plan, SQL
- Technical articles 2003-08-19
- Hypercharge Oracle SQL by using histograms
- The distribution of values within an index will often affect the cost-based optimizers CBOs decision whether to use an index or perform a full-table scan to satisfy a query. This can happen whenever the column referenced within a SQL query WHERE clause has a non-uniform distribution of values, making a...
- Tags: Oracle Corp., Donald Burleson, SQL, table column, cost based optimizer, histogram, Histograms
- Technical articles 2003-10-31
- Optimize SQL query speed with the Oracle clustering_factor attribute
- The cost-based optimizer CBO improves with each new release of Oracle, and the most current enhancement with Oracle9i is the consideration of external influences (CPU cost and I/O cost) when formulating an execution plan. As Oracle evolves into Oracle10g we may see even more improvements in the ability of the...
- Tags: Databases, Donald Burleson, cost based optimizer, column value, clustering_factor, Oracle Corp., selectivity
- Technical articles 2003-10-27
- Database management: Create a proper development environment for Oracle SQL
- In order to provide a consistent SQL execution environment in Oracle there are a number of environmental issues that should be addressed. By ignoring these issues you invite instability, acknowledged by ever-changing SQL execution plans, resulting in poor database query performance.Successful use of Oracle’s Cost-Based Optimizer CBO is heavily dependent...
- Tags: Programming languages, Databases, database management, database, Donald Burleson, development environment, SQL, execution plan, Oracle Corp., outline, Cost Based Optimizer, SQL execution plan
- Technical articles 2003-12-29
- 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
- Avaya Case Study: Midwestern Hospitals and Clinics
- In today's healthcare industry, the paperwork and coordination required between patient, facility and insurer can be daunting. The healthcare system needed a solution that would automate two critical applications for hospitals in its network. The hospital system selected an Avaya Interactive Response IR application and IQ Services, an Avaya DeveloperConnection...
- Tags: Hospital, Health Care, Avaya Inc., Healthcare, Vertical Industries, Benefits, Enterprise Software, Software, Human Resources
- Case studies 2007-07-01
- Database Optimization: Measuring Oracle disk I/O speed
- Because all Oracle databases retrieve and store data, the relative cost of physical disk access is an important topic. In Oracle, we see two types of data block access:db file sequential read—A single-block read (i.e., index fetch by ROWID)db file scattered read—A multiblock read (a full-table scan, OPQ, sorting)Physical disk...
- Tags: disk speed, Oracle Corp., Donald Burleson, disk, I/O, full-table scan, database
- Technical articles 2004-03-01
- Mandatory tagging?
- When we first launched tagging, we made it optional so that people could get used to it and see it in action.Now, however, we are thinking about making "Tags" a required field on the Start a thread page. The thinking is that, in order for tags to provide the most...
- Tags: feature, required field, sMoRTy71, tagging, tags, TR
- Discussion threads 2005-06-15
- 10 tips for customizing menus and toolbars in your Access apps
- This article is also available as a PDF download.A custom Access application shouldn't lay itself open tomisuse by giving users more options than needed. That means you'll probablyinhibit the built-in menu bar and toolbars and replace them with custom objectsthat provide only the options your users need. Fortunately, custom tools...
- Tags: built-in menu, Business applications, Microsoft Access, Microsoft Office, Susan Harkins, toolbar
- Technical articles 2007-01-03
- What to expect when you migrate to Oracle9i
- With the impending desupport of Oracle8i in December 2003, many shops are preparing to make their move to Oracle9i. So, what can you expect when you upgrade to Oracle9i? Actually, Oracle9i is very stable and most shops are quite thrilled with the performance improvements and new features. Let’s take a...
- Tags: Databases, Oracle9i, Donald Burleson, Oracle9
- Technical articles 2003-10-16
- Guard against performance issues when using Oracle hints and views
- Hints and views are powerful tools for Oracle tuning. Use them in combination, however, and you may take a serious performance hit. Find out why as we explain how these features work.Used separately, hints and views are terrific tools for Oracle tuning. But used together, they can cause severe performance...
- Tags: Performance management, Donald Burleson, Oracle Corp., materialized view, performance
- Technical articles 2002-02-13
- A nearly 3 TRILLION dollar federal budget has been submitted
- Anyone who believes President Bush is a fiscal conservative, send me an email and I'll give you a great deal on some ocean front property in Kansas.And if you think President Bush is bad, this won't be enough for the Democrat-controlled Congress. If they had their way, they'd spend even...
- Tags: maxwell edison, tax, off-topic, government
- Discussion threads 2007-02-05
- Optimize database code to boost performance
- Select COUNT(*) - secretSelect COUNT(*) DOES NOT do full table scan if table has a primary key. It counts the Index. Sometimes indexes may be 50MB for a 500MB table and Select COUNT(*) can be very fast! DB optimizition needs knowledge of programmer to get best out of the CBO...
- Tags: cursor, database, dept, performance, programming, SELECT, SELECT COUNT, sql erformance, sss@...
- Discussion threads 2006-09-27
- << Previous
- page 1 of 1
- Next >>
