SQL Optimization
1) The sql query becomes faster if you use the actual column names in SELECT statement instead of ‘*’. 2) Having clause is used to filter the rows after all…
1) The sql query becomes faster if you use the actual column names in SELECT statement instead of ‘*’. 2) Having clause is used to filter the rows after all…
-> In SQL Server, temporary tables are created at run-time and you can do all the operations which you can do on a normal table. These tables are created inside…
-> Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the…
-> An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to…
-> A simple view can be thought of a as a subset of a table. It can be used to retrieving data, as well as updating or deleting rows. Rows…
-> A trigger is an SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are used to maintain the referential integrity of data by…