fahad_direct - 11:40 am on Sep 12, 2010 (gmt 0)

Thanks. Actually my case is different, There is no parent/child relation in these 5 tablse as all these 5 are having the same level and same fields an i can't convert these in one so i am using union and can't use join and taking 5 to 8 hours time to map my each xml feed record with my inventory.
Any suggestion to improve.