If you query WHERE City='NYC' AND Age > 30, SQL doesn’t always need a single composite index. It can use Index Intersection.
It scans two separate indexes and finds the overlapping rows. However, for maximum performance, a composite index (City, Age) is usually superior because it avoids the merge step.