It can be used like a view in PAGES and people code but not stored in database as a sql view, instead the system uses the view text as a base for the sql select that is performed at runtime. These views shows superior performance in some situations such as search records and people code SELECTS.

Advantages of Using Search Views instead of Search Table

As the search view is created with selected fields there will not be MUCH stress on APP server and there by improves the performance. Search View also gives additional search criteria.

It can be used like a view in pages and people code but not stored in database as a sql view, instead the system uses the view text as a base for the sql select that is performed at runtime. These views shows superior performance in some situations such as search records and people code selects.

Advantages of Using Search Views instead of Search Table

As the search view is created with selected fields there will not be much stress on app server and there by improves the performance. Search View also gives additional search criteria.