Which two below reduce the likelihood of a Full Table Scan (FTS)?

Database

Which two below reduce the likelihood of a Full Table Scan (FTS)?

 A The primary index is fully qualified

 B The use of a WHERE clause in the query

 C The primary index is defined as compressed

 D A surrogate key is defined on the index column

Can anyone post me the correct answers for this question please?

1 REPLY
Enthusiast

Re: Which two below reduce the likelihood of a Full Table Scan (FTS)?

A