Which of the following is true about indexes and index design?

A. indexes should be created on columns used by WHERE and BY clauses
B. a composite index is an index on a single column
C. an index is created for every foreign key by default
D. indexes usually speed up write operations

Answer: A

Computer Science & Information Technology

You might also like to view...

Which fields are listed in the Create Source dialog box are determined by the ________ selected by the user

Fill in the blank(s) with correct word

Computer Science & Information Technology

_________ If the first argument is_________ , os.waitpid waits for any child of the current process,

a) the pid of a child process. b) –1. c) 0. d) None of the above.

Computer Science & Information Technology