A Comparative Analysis of Using Indexed View to Improve the Performance of SQL

Science Press Release Distribution Services

A Comparative Analysis of Using Indexed View to Improve the Performance of SQL

July 18, 2020 Engineering 0

This article is part of a collection of apps, operators and techniques related to the SQL Insert argument. In SQL, insert query is used to insert the record into database table. There are various ways are available to insert the record into table. Depend upon the requirement user can use the appropriate way of insert command. End user point of view, they may require summary of the data or only specific records at a glance. In such cases, aggregate functions are used. As we know aggregate function returns a single cell value. Clustered indexes are defined by the main importance of the data used in the list. The columns in the index description are the most significant values. Only one clustered index can be provided in increasing view, as only one series can organize the data rows themselves. A further benefit of having an index is that the optimizer continues to use the view index on questions that do not call the view explicitly in the FROM clause. Current queries may benefit from increased data recovery performance without re-coding from the indexed view

Author(s) Details

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

S. K. Kharade
Department of Mathematics, 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 :- http://bp.bookpi.org/index.php/bpi/catalog/book/205

 

Leave a Reply

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