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

Science Press Release Distribution Services

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

August 25, 2020 Mathematics and Computer Science 0

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 :- http://bp.bookpi.org/index.php/bpi/catalog/book/234

 

Leave a Reply

Your email address will not be published. Required fields are marked *