DBAs and Developers, (but those most likely to suffer sado-masochist or self-harm tendencies)
This session is based off research performed on objects, design and code built as similar as possible to see how Oracle and SQL Server compare in performance, usage and storage of indices. Based off trusted measurements in each platform, dig into how the use case was built, the similarities and the differences in each.
Based off this use case, then Kellyn will build out more advanced index features and 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 resources.
- 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.