I have a query - the showplan shows no table scan - but the entity bean for the query has 6 clobs and 6 on-to-one relationships (legacy datamodel). My query takes a long time to run despite being fully indexed. HOWEVER, when I run it for just a small set of fields needed for the current form it comes back very quickly - How do I get this quick query to populate the entity bean for the table, yet still be able to load the other entity bean fields later as needed - I was thinking lazy loading, but dont know how - Is that the right approach? If so are there examples?
