Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Wednesday, 26 August 2020

Usage of Unique Key for Improvement of Performance in Table Scanning | Chapter 4 | Recent Advances in Science and Technology Research Vol.4

 

Database efficiency is a common topic of focus when dealing with data bases in business

environments. There is a prerequisite that the database is accessible and function well as corporate

systems rely on back-end resources to support them. Moreover, Query optimization is where a client,

or the database engine, adjusts a query in such a way that SQL Server can more effectively return the

same results. Thinking about the output of systems using the common principles of supply and

demand may be helpful. Users are demanding the DBMS details. The DBMS supplies the information

to those who need it. The pace at which the DBMS supplies the demand for information can be

described broadly as "database efficiency." Knowing what the performance of the database is must be

a requirement for properly ensuring the database environment is effective. The maintenance of data

base output is an feasible job with a clear concept in hand.

Author (s) Details

S. K. Kharade

Department of Mathematics, Shivaji University, Kolhapur, India.

K. G. Kharade

Department of Computer Science, Shivaji University, Kolhapur, India.

R. S. Kamath

Department of Computer Studies, Chhatrapati Shahu Institute of Business Education and Research (CSIBER), Kolhapur, India.

R. K. Kamat

Department of Electronics, Shivaji University, Kolhapur, India.

 

View Book :- https://bp.bookpi.org/index.php/bpi/catalog/book/240

Wednesday, 19 August 2020

Selection of Small Index to Reduce the Number of Pages for Improving Efficiency | Chapter 5 | Recent Studies in Mathematics and Computer Science Vol.4

 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