IT 기반 지식 및 유용한 TIP IT 기반 지식 및 유용한 TIP

HANA DB 쿼리 참조 https://help.sap.com/viewer/7c78579ce9b14a669c1f3295b0d8ca16/Cloud/en-US/6fff7f0ae9184d1db47a25791545a1b6.html Index Aggregate Functions AUTO_CORR Function (Aggregate) AVG Function (Aggregate) CORR Function (Aggregate) CORR_SPEARMAN Function (Aggregate) COUNT Function (Aggregate) CROSS_CORR Function (Aggregate) DFT Function (Aggregate) FIRST_VALUE Function (Aggregate) LAST_VALUE Fu..

hana db monitoring handy sql https://www.scribd.com/document/319167030/Hana-Monitoring-Handy-Sqls#download 관리 쿼리 -- TABLE List select * from tables select * from public.tables select * from SYS.M_TABLES where table_name like 'DP_TC_PRM_EXCEL_TO_DB_TYPE%' -- COLUMN 정보 확인 select * from table_columns where column_name = 'COMPANY_CODE' select schema_name, table_name, column_name, NUMA_NODE_INDEXES f..