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.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
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
.