Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 18 of 58
M_Expensive statement in SAP HANA
This can be checked using system view M_EXPENSIVE_STATEMENTS.SELECT * FROM M_EXPENSIVE_STATEMENTSIn SAP HANA, the M_EXPENSIVE_STATEMENTS view provides convenient access to the most expensive statements that were executed on the system. A statement is considered being expensive if its runtime exceeds a particular threshold. Please note that the expensive statements trace needs to be activated first in the Performance → Expensive Statements Trace screen in the SAP HANA studio. Click Configure the Trace Configuration dialog
Read MoreChecking information about basic I/O operations on I/O subsystems in SAP HANA
You can make use of M_VOLUME_IO_TOTAL_STATISTICS System View which shows information about basic I/O operations on I/O subsystems (paths).
Read MoreDisk utilization and configuration details view in SAP HANA
You can make use of M_DISKS System View which provides information about disk configuration and utilization of the host machine.SELECT * FROM M_DISKS;
Read MoreChecking System limits in SAP HANA
M_SYSTEM_LIMITS is a view to getting SAP HANA system limits. You can query this view to find the limitations of HANA system −SELECT * FROM M_SYSTEM_LIMITS;It will provide you details about Database Limitation Schema Limitations Tables and View Limitation Indexes and Constraints SQL SQL Script
Read MoreMaximum Column name length in SAP HANA
Maximum column name length supported in a table in SAP HANA is 127 chars.
Read MoreMaximum number of columns in a table in SAP HANA
The maximum number of columns in a table is 1000.
Read MoreMaximum Table name length in SAP HANA
Maximum table name length supported in SAP HANA is 127 characters.
Read MoreMaximum table count in a schema in SAP HANA
In SAP HANA, a maximum number of tables in a schema are 131072. To create a table, you have to right click on Schema name → New Table
Read MoreUsing an Analytic Privilege for specific time in SAP HANA
Yes, when an Analytic Privilege is defined you have an option of using it for a specific time period. You have an option of defining Privilege validity where you can pass validity details.You can also opt for SQL Editor or Dynamic where you can pass different validity conditions. When you use SQL option you can pass a SQL query and it will be set as per SQL queryFor Dynamic option, you can pass Stored Procedure to define validity.
Read More