Omnidex allows indexes in a child table to also store pointers to the parent table. This improves the performance of joins between that child and its parent. These indexes require more overhead, but that can be easily offset by the performance gains on queries.
See also: