Hi,

As u can see, the indexed table has relationship with another table. If there is no record with related table, then I am trying to index on a field in first table otherwise index on a field of second table. Let me know if I am still unclear.

Thanks for your reply.