Hi Jeff and Scott thanks a lot for great explanations and i learned good lesson from your replies. I would like to through a point that all these tables are my sample tables that i needed to share on this forum to play with. My production table is having proper naming conventions.
Please advice me how to find the missing indexes on the tables.