october, 2021


Warning: in_array() expects parameter 2 to be array, bool given in /home/customer/www/groupby.org/public_html/wp-content/plugins/eventON/includes/calendar/class-calendar-event-structure.php on line 60

26oct3:30 pm5:00 pmIndexes vs. Histograms to Speed Up Database SearchesDave Stokes

Event Details

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

more

Virtual Event Details

Event has already taken place!

Time

(Tuesday) 3:30 pm - 5:00 pm UTC