Do I need to make sure I re-create every index on every child table I create?
That would be.. annoying, at best.
Is there a way to enable inheritance of indexes too?
You do not need an index on the master table so create indexes on child tables only. This way you are avoiding big index scans and only looking at the index on the data you are interested in (child table).
cheers,
Shoaib
