Indexes vs. Histograms to Speed Up Database Searches | Dave Stokes
Want to learn more about GroupBy’s Sponsors? Check them out below!
SolarWinds: https://loom.ly/ljHr3eg
Redgate: https://loom.ly/Q65t2z0
Data Masterminds: https://loom.ly/JgisLIw
SSG: https://loom.ly/MotcEjE
Your relational database’s optimizer is like a GPS in that it depends on historical information on where data is located. Indexes let you go directly to the records or records desired IF you know what you are searching for. Plus there is overhead for each insert, update, or delete with an index. Histograms do not have that overhead, provide a way to inform the optimizer where the data points are, and can also greatly speed searches. But when is one better than the other? Well, the answer to that question and few other questions will be found in this session.
Download Session Materials here: https://drive.google.com/drive/folder...