when i need fullText
index for two attributes, which one should i go with? should i create two fullText
type indexes with the attributes on each? or should i include both of the attributes in a single fullText
type index? which one is more recommended and what are the differences?
TL;DR
Title: Multiple `fullText` indexes or one `fullText` index with multiple attributes?
Message: As a developer, I want to know if I should create two separate `fullText` indexes, each with one attribute, or include both attributes in a single `fullText` index. What is the recommended approach and what are the differences?
Solution: It is generally recommended to use a single `fullText` index with both attributes included. This approach allows for more efficient searching and better performance.