procedure and function

[jisuprusty]

help me
we know that we are using procedure for DML operations and function for
CALCULATION purpose . I want to know that why????

[debasisdas]

Since procedures and functions are pre compiled objects the sql statments are not re-parsed during execution. So performance wise it is better than same SQL executed independently which is parsed everytime before execution.