If you index on the file_name in a table where you have file_name and a blob then why would it trash performance? SQLite can quickly locate where to start read

If you index on the file_name in a table where you have file_name and a blob then why would it trash performance? SQLite can quickly locate where to start reading the blob.