Statistics in Oracle and SQL Server

Presented by Jonathan Lewis (Oracle ACE Director, OakTable) and Grant Fritchey (SQL Server MVP)

Weds 23rd January 2013



This webinar has now finished, but feel free to click the button above to watch the recording.

If you missed the Q+A, or we were unable to answer your question, or you would like to ask the presenters a new question, please use the comments function under the post on: All Things Oracle.com.

Summary


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.

Do 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.



Jonathan Lewis


SQL Compare visually indicates differences in database objects

Jonathan Lewis is a well-known figure in the Oracle world with more than 23 years' experience using the software. He is a founding member of the OakTable Network and Oracle ACE Director. Jonathan has published two books about Oracle, has contributed to three others, and has just completed a new book (Oracle Core: Apress) on the Oracle database engine. He runs a couple of websites and contributes fairly regularly to newsgroups, forums, and User Group magazines and events around the world.

Grant Fritchey


SQL Compare visually indicates differences in database objects

Grant Fritchey is a SQL Server MVP, and highly respected SQL Server DBA and developer. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG) and it's current president.

Deployment Suite for Oracle

Compare, deploy and source-control Oracle databases. Learn more.

Source Control for Oracle

Source Control for OracleEnables easy Oracle database source control. Learn more.

Schema Compare for Oracle

Schema Compare for OracleThe fast way to compare and update Oracle schemas. Learn more.

Data Compare for Oracle

Data Compare for OracleDatabase diff tool for Oracle table data. Learn more.