TYPE_SCROLL_INSENSITIVE vs. TYPE_SCROLL_SENSITIVE

• An insensitive resultset is like the snapshot of the data in the database when query was executed.
• A sensitive resultset does NOT represent a snapshot of data, rather it contains points to those rows which satisfy the query condition.

• After we get the insensitive resultset the changes made to data are not visible through the resultset, and hence they are known as insensitive.
• After we obtain the sensitive resultset if the data is modified then such modifications are visible through resultset.

• Performance not effected with insensitive.
• Since a trip is made for every ‘get’ operation, the performance drastically get affected with sensitive.