I'm having a table in which i have images stored in blob ..
I want to know what would be the best indexing technique for this table to fetch & update the records faster.
I'm having almost 200000 records in the table,
the table structure will be like id (auto_increment column),slideid, name, image
Please suggest a better indexing tech...