DBAs and Developers, (but those most likely to suffer sado-masochist or self-harm tendencies)
This is an exercise in the love of learning and the love of databases technology. Based off trusted measurements in each platform, we’ll dig into how the use case was built, the similarities and the differences in each database platform.
The second part of the session will be to build out more advanced index features, discuss the advantages, reasons for the introduction and how it’s effected the direction of each product, the DBAs who are responsible for them and maybe even a few database religious discussions!
The session is based off historical research performed on objects, design and code built as similar as possible to demonstrate how Oracle and SQL Server compare in performance, usage and storage of indices, (aiming for “apples” to “apfel”.)
- Receive a strong education on platform differences between Oracle and SQL Server.
- Discover hidden insight on index storage and costs.
- Learn about great tips on maintaining index health and where a database platform may perform better than another.
- Translation of common features in both platforms
Why I Want to Present This Session:
My goal is for attendees to put their preferences aside to [possibly] admire the goal of different features in an opposing platform, (no matter if they specialize in Oracle or SQL Server.) Knowledge is power and understanding the differences in the two most popular database platforms, how index data is managed by the database engine, along with how the optimizer hinders and enhances index availability to SQL.