What action can bes...
 
Notifications
Clear all

What action can best improve the query performance?

1 Posts
1 Users
0 Likes
45 Views
Arden
(@boehnkearden)
Noble Member
Joined: 6 months ago
Posts: 336
Topic starter  

You have a database where queries are performing slowly.

Investigating the results, you find that the database is performing a time-consuming table scan.

What action can best improve the query performance?

  • A . Sub setting the records.
  • B . Parameterizing the query.
  • C . Recompiling the query.
  • D . Adding an index.

Show Answer Hide Answer

Suggested Answer: D

Explanation:

You create an index to optimize performance when searching the table using the Find function and to establish uniqueness of table columns.

Indexing makes columns faster to query by creating pointers to where data is stored within a database. Imagine you want to find a piece of information that is within a large database. To get this information out of the database the computer will look through every row until it finds it.

   
Quote
Topic Tags
Share: