Oracle vs. SQL Server Indexing- The Good, the Bad and the Ugly
This session is based off research performed on objects, design and code built to be 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, we’ll dig into how the use case was built, the similarities and the differences in each. What we can admire about how each product has matured in the way of managing index data, statistics and how the optimizer hinders and enhances index availability.
1. Receive a strong education on platform differences between Oracle and SQL Server.
2. Discover hidden insight on index storage and costs.
3. Learn about great tips on maintaining index health and how one platform may perform better than the other and how.
4. Translation of common features in both platforms