Register Log in

Statistics in Oracle and SQL Server

Comments 0

Share to social media

This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a response and ask questions at the bottom of the page.

This webinar features a demonstration of Schema Compare for Oracle. You can download a free 14 day trial here: Download Schema Compare for Oracle.

The better the information that Oracle and SQL Server have about the data in a database, the better choices they can make on how to execute the SQL. Statistics are Oracle’s and SQL Server’s chief source of information. If this information is out of date, performance of queries will suffer.

In their third live ‘Oracle vs. SQL Server’ discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server.

Does Oracle and SQL Server gather the same information? What does each optimizer use this information for? And how can Oracle and SQL Server administrators override the defaults for better (or worse) performance? These are just some of the questions that Jonathan and Grant will try to answer in another not-to-be-missed session.

As before, this will be a live discussion with limited supporting slides, and will conclude with a Q+A session with Jonathan and Grant. Be prepared for a lively exchange that will not only entertain, but will teach you key concepts on Oracle and SQL Server.

Load comments

Recommended

About the author

Jonathan Lewis

See Profile

Jonathan Lewis is a well-known figure in the Oracle world with more than 30 years’ experience using the software. He has published three books about Oracle – the most recent being “Oracle Core” published by Apress Nov 2011 – and contributed to three others. He has posted more than 1,400 articles on his blog and has spent a lot of his time contributing to newsgroups, forums, and User Group magazines and events around the world. Jonathan has been self-employed for most of his time in the IT industry. For the last 25 years he has specialised in short-term assignments – typically of a design, review, or troubleshooting nature – often spending no more than two or three days on a client site to address problems. After visiting more than 50 countries (and more than a dozen US states) to talk about or troubleshoot Oracle systems, he has finally gone into near-retirement, though still writes articles and does a little consulting over the internet. Despite the differences in the software, he finds that the fundamental principles of solving performance issues don't really seem to change as you move from Oracle to SQL Server. His blog can be found at http://jonathanlewis.wordpress.com.

Jonathan's contributions
Jonathan's latest contributions: