i have implemented a query search for all entries with the year 2014 by following code. Can we consider this design of index and select optimal for given query from performance perspective?
CREATE INDEX item_idx ON item (created);
SELECT text, created
FROM item
WHERE YEAR(created) = '2014’;
is it an optimal solution or there can be an improvement possible ?