Selection of Table Scan or Seek Scan on the Basis of Data Size to Reduce Number of Logical Reads | Chapter 3 | Theory and Practice of Mathematics and Computer Science Vol. 1

The information retrieval system is an effort to extract services from a range of knowledge services, which are

specific to the information requirement. You will access this method using passwords or keywords or a user

query. Databases and documents are usually limited to different organizational framework managed by the

DBMS and the Information Retrieval Systems (IRS). Both DBMS and IRS, though, frequently store data on the

same individuals, providing convergence opportunities. In the modern world, it has become necessary to retrieve

the information in very efficient manner and within a very less time. But being availability of data in very large

size, information retrieval form database become slower which may affect the overall performance of the

system. For this, various methodologies have been implemented in all DBMS software. In addition, it becomes

mandatory to use proper technique for the better and faster result. Table scan and seek scan have integrated in

the DBMS for the same purpose. In the current research, we have compared both methods for better

performance [1].

Author (s) Details

S. K. Kharade

Department of Mathematics, Shivaji University, Kolhapur, India.

K. G. Kharade

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

V. S. Kumbhar

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

R. K. Kamat

Department of Electronics, Shivaji University, Kolhapur, India.

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

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

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