Access articles and resources written by some of the best Oracle brains in the world.
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.
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 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 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.
- Compare 2 schemas and see highlighted differences side-by-side
- Automatically create update scripts to migrate any changes