You have a table created as follows:create table foo (c1int, c2 char(30), c3 int, c4 char(10))If column c1 is unique, wh

Answers to popular Homework/Schoolwork assignments, tests, and more.
Post Reply
homeworkanswerdumps
Site Admin
Posts: 343124
Joined: Mon May 16, 2022 9:31 am

You have a table created as follows:create table foo (c1int, c2 char(30), c3 int, c4 char(10))If column c1 is unique, wh

Post by homeworkanswerdumps »

You have a table created as follows:create table foo (c1int, c2 char(30), c3 int, c4 char(10))If column c1 is unique, which of the following indexes would optimize the statement given below? Select distinct (c1), c3 from foo where c1=10

A. create unique index foox on foo (c1) include (c3)
B. create index foox on foo (c1)
C. create index foox on foo (c1,c3)
D. create unique index foox on foo (c1,c3)
Register for FREE to view solutions, replies, and use search function.

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply