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.
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
The default file name of a Microsoft Excel file is ________
A) Excelfile1 B) Workbook1 C) Book1 D) Excelbook1
To place the insertion point in the contents of a cell, you ________ the cell
Fill in the blank(s) with the appropriate word(s).
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?