What is the best indexing method for a table which has images?

[kvijayhari]

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...

[Dan Grossman]

The indexes you need depend on the queries you're going to issue against this table, not whether there's an image in the table or not. Look at the queries, and apply indexes on those columns you use for joins and in where conditions.

[PHPycho]

Generally
foreign keys
fields used in where caluse needs to be indexed.

[kvijayhari]

Usually my query will be to fetch the images based in slideid and name