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


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.