The documentation on Connect Engine ODBC - which Connect Engine JDBC references - is very unclear with regards to the Memory option. Suggest a clean rewrite of that doc section.
Memory=0 what does it mean? can it be used with order by? can it be used with random access (columns specified as indexed)?
Memory=1 same questions
Memory=2 same questions
similar to but not directly related, a new section clearly indicating how random access is enabled
if column is indexed - what will happen?
if column is not indexed - what will happen?
how do these interact with the scrollable option?