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.

JOIN THIS SESSION HERE: https://groupby.org/attend