Optimisation

When we go for optimisation, we need to think about

1. Index
2. Explain Plan
3. Analyse table
4. Response time etc

DBMS_METADATA.GET_DDL

Select DBMS_METADATA.GET_DDL('object type', 'object name', ' owner')
From dual;

Try this