If you anticipate running a particular query often,you can improve overall performance by saving the query in a special file called a(n)____.
A) index
B) stored procedure
C) trigger
D) view

Question

If you anticipate running a particular query often,you can improve overall performance by saving the query in a special file called a(n)____.​
A) ​index
B) ​stored procedure
C) ​trigger
D) ​view

Quizplus · Accepted Answer

A stored procedure is a precompiled and stored collection of SQL statements, which can be executed later with the help of a stored procedure name. By storing the frequently used query in a stored procedure, we can reduce network traffic and improve overall performance.

If You Anticipate Running a Particular Query Often,you Can Improve