SQL Console allows you to write an SQL statement and analyze the query performance.
Feature | How to use? |
---|---|
Check | In SQL Console, choose Check. This feature verifies the syntax of a
query. Note SQL Console also performs an automatic syntax check and
instantly highlights any errors in syntax. For proper functioning of the
automatic syntax check, ensure that the option Automatic
Syntax check on all open ABAP source editors is selected
in Eclipse. This option is available under the Eclipse menu option .
|
Run | In SQL Console, choose Run to execute a query.
In an SQL statement with multiple queries, if you want to execute a specific
query, highlight the query and choose Run. Note The
Run drop-down menu contains following
options:
|
Data Aging | The Data Aging option allows you to view the most frequently accessed data (hot data) in your database. This feature is available only for the HANA database. The Data Aging option does not appear if you open Data Preview in other database. |
Max Rows | In SQL Console, enter a value for Max Rows. Data Preview considers only this value while displaying records. Maximum row value provided in the SQL statement is not considered. |
Content Assist | In SQL Console, press CTRL + spacebar. |
Tooltip Support | In SQL Console, press F2 on any DDIC artifact or DDIC component. |
Query Performance | SQL Console is split into two windows. The top window provides you the option of entering an SQL statement and the bottom window provides query related statistics. |