A composite index is composed of multiple columns. These columns can be a mixture of user-defined and system-defined properties or be entirely of one type.
To understand what columns are needed in a database index to support a fast database query, you must have some understanding of the following mechanisms: how Content Platform Engine processes searches and how searches are issued against the database.