Find largest table in a SQL Server database Monitoring table size over time is very important to the SQL Server Engine. In performance point of view to run queries. At the most optimal and avoid performance issues due to larger table size as it important factor in SQL Server performance There are often many times people ask, how to find the largest tables/objects in a database, so below scripts, will determine which objects in a database are largest. SELECT t.name AS TableName, i.name as indexName, sum(p.rows) as RowCounts, sum(a.total_pages) as TotalPages, sum(a.used_pages) as UsedPages, sum(a.data_pages) as DataPages, (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, (sum(a.data_pages) * 8) / 1024 as DataSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.object_id = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id WHERE t.name NOT LIKE 'dt%' AND i.object_id > 255 AND i.index_id <= 1 GROUP BY t.name, i.object_id, i.index_id, i.name ORDER BY TotalSpaceMB DESC

How many types of Sql Statements are there in Oracle?

Smith

How many types of SQL Statements are there in Oracle?

Vikash

There are basically 6 types of SQL statements.
They are as follows
a) Data Definition Language(DDL)- The DDL statements define and maintain objects and drop objects.
b) Data Manipulation Language(DML)- The DML statements manipulate database data.
c) Transaction Control Statements- Manage change by DML
d) Session Control- Used to control the properties of the current session enabling and disabling roles and changing
e.g- Alter Statements, Set Role
e) System Control Statements- Change Properties of Oracle Instance e.g- Alter System
f) Embedded SQL- Incorporate DDL, DML, and T.C.S in Programming Language. e.g:: Using the SQL Statements in languages such as 'C', Open, Fetch, execute, and close