Hi there!
I need to implement a new query due to a new application requirement.
If i have a table with dozens of columns and thousands of rows, what
is the most efficient way to select only a few columns (say 10-20) for
a limited number of rows (say 5%)?
The different ways i've thought of include:
- create a prepared statement with those columns specified, and:
- retrieve each row with an individual select statement, or
- use "where recordid in (...)" to specify the rows
- create a view with those columns included, and:
- retrieve each row with an individual select statement
- use "where recordid in (...)" to specify the rows
Which is likely to be the most efficient in H2? Is there any
performance penalty for creating views? Since the field list is
likely to vary, is there any problem with creating and dropping these
views every time the application is opened? Is there a way to create
temporary views?
Thanks in advance,
Paul
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
