If your use case is not site facing with a strict low latency requirement, the inverted index will provide good performance for most use cases.
You should start by adding an inverted index and if the query does not perform as per the expectations switch to advanced indices such as sorted column and star-tree index.