Selection of Small Index to Reduce the Number of Pages for Improving Efficiency

Exact data figures are used for having the right method for the execution of SQL queries. Yet you can get the
badly performing question where the numbers do not correctly represent the actual table information. Stats are
important information used by the Database Optimizer SQL Server that influences the chosen database
execution schedule. The optimizer gets its awareness of the data, its distribution and, from statistics available,
the number of rows of a specific question that return. Depending on this information, it selects the optimal
access route, whether to search a table or to try an index, using a nestled loop link or a hash link, etc.

Author(s) Details

K. G. Kharade
Department of Computer Science, Shivaji University, Kolhapur, India.

S. K. Kharade
Department of Mathematics, Shivaji University, Kolhapur, India.

S. V. Katkar
Department of Computer Science, Shivaji University, Kolhapur, India.

R. K. Kamat
Department of Electronics, Shivaji University, Kolhapur, India.

View Book :-

Leave a Reply

Your email address will not be published.

Previous post Investigation on Stackelberg Game for Product Renewal in Supply Chain
Next post Technical Approach in Enhancing Electronic Banking Security inNigeria Using Finger Vein Biometric