ADF View criteria Execution Modes

What are the different types of Execution Modes in ADF

There are 3 types Execution modes fro a view criteria that can be helpful in filtering out the data

1) Database: The search results are filtered from the Data base table every time the query is hit.

2) In Memory: The results are filtered from the VO cache memory. It will use the rows which are already in the row set. It will stop the unnecessary hits to the DB.

3) Both: The results are filtered from the existing row set and also from the filtered results from Database. This is useful when you want to filter from uncommitted records also.

Below scenario will explain the different types Execution Modes.

I have search criteria and result component as table to show the results. 

1) Execution Mode is DataBase in view criteria.

    There are 2 employees by the first name Steven. When we search for Steven it will show 2 records as          shown below.

I will add one more employee with the name Steven Gerrard, without saving i will search for Steven, it will show only 2 old employees.

2) Now changes the Execution Mode to 'Both' in the employee view criteria. Add new Record with the name Steven Gerrard, and do not commit the record into the DB, it will be in VO cache memory

3) Now search for Steven, it will show all the 3 Steven records. 2 from the DB and one from the VO cache memory as shown in below image.