DEV Community


Discussion on: Working with Legacy, a tale of a slow query.

willmenn profile image
William Ahrons Author • Edited

Hi Herb, I forgot to mention that, so the query was time-based, so adding an index in that column was to sparsed, and the other column that we were filtering was not giving that much of division in the table, so basically if we add an index in the other column we would divide the table into 100 small ones. That answer your question?

The query was basically: Select all records from the lastweek for my store.

Forem Open with the Forem app