Oracle Heap Tables or SQL Server Clustered Indexes?

Live discussion between Jonathan Lewis and Grant Fritchey.

Thurs 7th June 2012

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

Oracle and SQL Server may both share a common language, but certain things are handled quite differently. Jonathan Lewis (OakTable Network, Oracle Ace Director) is used to seeing heap tables (almost) everywhere, but Grant Fritchey (Microsoft SQL Server MVP) is used to seeing clustered indexes (almost) everywhere. But which arrangement performs better? And is comparative performance even the right thing to measure?

In this live discussion, these two heavyweights in their respective technology areas will debate the pros and cons of Oracle Heap Tables and SQL Clustered Indexes. Jonathan and Grant may even play a few unexpected cards during the discussion. Be prepared for a lively exchange which will not only entertain, but will teach you key concepts on Oracle and SQL Server.

Jonathan Lewis

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

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.