What happens if there is no index defined for a query?  What is its impact?

What will be an ideal response?


If no index is defined, a query will require the database engine to undertake a full table scan on every record within the table in order to find matches. For large tables, this has a serious impact on performance.

Computer Science & Information Technology

You might also like to view...

The algorithm that can run in O( n ) time if the elements are nearly sorted, yet does not depend on the range of values, is:

A. insertion sort B. quicksort C. counting sort D. heapsort

Computer Science & Information Technology

Specifying a port that is already in use or specifying an invalid port number when creating a DatagramSocket results in a __________.

a. SocketException. b. PortInUseException. c. PortException. d. ConnectException.

Computer Science & Information Technology

In ________ view, the PowerPoint window is divided into two areas–the Slide pane and the left pane

Fill in the blank(s) with correct word

Computer Science & Information Technology

If you set a database _____ all users must enter that combination of characters before they are allowed to open the database.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology