Hi Gurus,
Can anybody please let me know how to find out when were the optimizer statics updated last time ?
Last time Update Statistics
Updated May 18, 2018
Comments
Recommended Posts:
- SAP BASIS Full Form & Meaning
- SAP BASIS Training Tutorials for Beginners
- How to Check SAP Version
- Lock/Unlock SAP T-Codes via SM01
- Reset SAP* Password
- What is SAP Router
- SAP Work Process
- Assign Authorization Object to User in SAP
- SAP STMP Mail Configuration
- SAP Compatible Printers
- Check SAP Services in Linux and Unix
- SAP Schedule Background Job
- SAP Background Jobs List
- Stop Scheduled Background Job
- SAP SPRO Full Form
- SAP Spool Overflow
- Difference between DDIC and SAP
- SAP Basis Backup Type
- Compare User Roles in SAP
- SAP BASIS Scope and Opportunity
×
SELECT
OWNER,
TABLE_NAME,
NUM_ROWS,
SAMPLE_SIZE,
TO_CHAR(LAST_ANALYZED, 'dd.mm.yyyy hh24:mi:ss') LAST_ANALYZED,
TO_CHAR(LAST_ANALYZED, 'yyyy') LAST_ANALYZED_YEAR
FROM
DBA_TABLES;
Prasad Pithani