In this scenario, what is the best practice for creating a database index (or indexes)?

Assume that a company uses ApsaraDB for PolarDB. The company commonly queries users based on their basic information, including: addresses, company names, and ID numbers.

In this scenario, what is the best practice for creating a database index (or indexes)?
A . Create a b-tree index on each column to be searched.
B . Create a hash index on each column to be searched.
C . Create a gin index for multiple fields.
D . Create a gist index for multiple fields.

View Answer

Answer: C