Agents giving better results than VectorstoreIndexCreator

Thanks for this course.

I noticed that this course mentions VectorstoreIndexCreator in general for Document Q&A. It works fine for small documents like PDF etc. However I notice that specific agents do much better. E.g. with a small 9 MB 50 column 3500 rows CSV the VectorstoreIndexCreator based results are dismal. Hence I resorted to more fundamental CSVAgent and the results were much better.

Is that expected? If so, any guidance on when to use VectorstoreIndexCreator vs specific agents etc.