= Multiple indexes matched with AND

This example uses the following table and indexes:

[source,sql]
----
include::cassandra:example$CQL/sai/create-vector-table-cycling.cql[tag=createvstable]
include::cassandra:example$CQL/sai/index-sai-multiple-index-match-with-and.cql[]
----

Several indexes are created for the table to demonstrate how to query for matches on more than one column.

Query for matches on more than one column, and both columns must match:

[tabs]
====
Query::
+
--
[source, console]
----
include::cassandra:example$CQL/sai/index-sai-select-multiple-index-match-with-and.cql[]
----
--

Result::
+
--
[source,results]
----
include::cassandra:example$RESULTS/sai/index-sai-select-multiple-index-match-with-and.result[]
----
--
====
