Notifications
Clear all
Topic starter
10/08/2022 8:53 am
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.
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.
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.