I have a table heirarchy of around 5 tables. At places where i have to do a search with criteria ranging on all these tables, will it be advisable to have a join on all the tables. A couple of tables can run into million of rows. Is it advisable to do an iterative search by joining two tables and going down the heirarchy (which will end up in selecting more and narrowing down with each subsequent level) or is it better to do a join in one go and...