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

Kharade, K. G. and Kharade, S. K. and Kumbhar, V. S. and Kamat, R. K. (2020) A Comparative Analysis of Using Indexed View to Improve the Performance of SQL. In: Recent Developments in Engineering Research Vol. 1. B P International, pp. 6-13. ISBN 978-93-90149-19-3

Full text not available from this repository.

Abstract

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.

Item Type: Book Section
Subjects: Pustaka Library > Engineering
Depositing User: Unnamed user with email support@pustakalibrary.com
Date Deposited: 03 Nov 2023 04:55
Last Modified: 04 Nov 2023 09:45
URI: http://archive.bionaturalists.in/id/eprint/1746

Actions (login required)

View Item
View Item