Hello k f,
1. The amount of queries depends on the kind of references in your model. If there are references to the 3 additional tables we will join them into the first result, If there are collections (backward FKs in the db) we will have 3 additional queries. Means something between 1 and 4.
2. No, with FetchPlan the idea is, that you look at the slow page, find out which data is loaded and just set a plan for this page or business case. Most of the pages are working well, only some are executing to many queries, you can also count the amount od sql statements per page and do your optimization with that input.
All the best,
the Telerik team
Check out Telerik Trainer
, the state of the art learning tool for Telerik products.