List three query design guidelines that can help reduce demands on the physical resources while providing an improvement in performance.

What will be an ideal response?


Avoid operators, such as LIKE, that add significant overhead to the query. Useful in certain
circumstances, the LIKE operator will result in a full table scan that causes the database to
evaluate every row in a table to produce a result set.

In the SELECT statement, specify only data that is actually needed in the result set. Avoid using * as a substitute for column names.

Sorting is a memory-intensive operation and should only be performed if absolutely necessary.

Use fully qualified names when referring to database objects in a query. This saves the overhead of the database engine having to resolve the logical name each time the query is run.

Include all columns that are part of a foreign key in a JOIN clause.

Avoid placing implicit or explicit functions in the WHERE clause; for example, subqueries will significantly degrade performance.

Computer Science & Information Technology

You might also like to view...

Which of the following risk assessment methodologies was originally developed by CERT?

A) FAIR B) OCTAVE C) RMF D) CMM

Computer Science & Information Technology

The default file name of a Microsoft Excel file is ________

A) Excelfile1 B) Workbook1 C) Book1 D) Excelbook1

Computer Science & Information Technology

To place the insertion point in the contents of a cell, you ________ the cell

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

Computer Science & Information Technology

A form contains six radio buttons. Three of the radio buttons are located in a group box. How many of the radio buttons on the form can be selected at the same time?

What will be an ideal response?

Computer Science & Information Technology