You must be registered to use and view the SEARCH and for full board access! Join a community of subject matter experts for free.

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: 341468
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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function!
For more answers visit our other sites: AnswerAccurate HomeworkAnswerHelp QuestionAnswerDump and AnswerHappy

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