IBM Db2 LUW Global Temporary Table Scope and Hibernate Pagination Behavior
Problem Statement Global temporary tables in IBM Db2 LUW can have session-specific or transaction-specific scope, which affects how query plans are cached and reused. When Hibernate generates paginated queries using setFirstResult/setMaxResults, the interaction between temporary table scope and pagination logic may produce inconsistent SQL or execution plans
hibernate