Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Stack Overflow for Teams is now called Stack Internal. Bring the best of human thought and AI automation together at your work.
Bring the best of human thought and AI automation together at your work. Learn more
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
You use a date format function in the whereWHERE clause.
WHERE
This function then means that the query cannot use an index on the date column.
Removing the date format function in the whereWHERE clause will improve the performance of the query.
You use a date format function in the where clause.
Removing the date format function in the where clause will improve the performance of the query.
You use a date format function in the WHERE clause.
Removing the date format function in the WHERE clause will improve the performance of the query.
You use where clause ina date format function in the where clause.
DateThis function use then not workingmeans that the query cannot use an index on the date column.
So please use where clause withoutRemoving the date format function in the where clause will improve the performance of the query.
You use where clause in date function.
Date function use then not working index.
So please use where clause without date format
