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...
A ________ document serves as a container for the different parts of a Word document
A) new B) master C) combined D) subdocument
Computer Science & Information Technology
What cloud computing characterization would often be used by software developers?
A) SaaS B) IaaS C) XaaS D) PaaS
Computer Science & Information Technology