I have an object Property and it has fields like

private City city;

private TransactionType transaction_type;

For some cities and transaction_types I want to store them in different tables (to optimize queries - not sure if its the correct approach).

1)How can it be done?
2)I am not sure if storing in different tables after checking the values of fields is the correct approach to reduce time taken by queries.. Any suggestions/comments ?

P.S. : I am completely new to hibernate..so excuse me if this question is too basic and any references to resources will be greatly appreciated..

I think I probably need a little more details to make a suggestion, but I find it a little strange that you have an object called Property which has a City and a Transaction type. This doesn't seem very OO.

I'm not really sure of your context, but hibernate has several ways of doing inheritance (discriminators, etc). Also things like cities an typical database model may be to have a single city table and many cross reference tables that point your main object (which implies a many-to-many relationship).

I think a little more context of what you're trying to do might be helpful.