Given a table created as shown below: create table foo (c1 int, c2 int, c3 int, c4 char(10)) If column c1 has a cardinality of 10, column c2 has a cardinality of 5000, and column c3 has a…

Given a table created as shown below: create table foo (c1 int, c2 int, c3 int, c4 char(10)) If column c1 has a cardinality of 10, column c2 has a cardinality of 5000, and column c3 has a cardinality of 5000000, which of the following indexes would optimize the following statement? Select c1,c2,c3 from foo where c1=100 and c2= 100 and c3 = 100