BadhiJanne Jee,
If you did this decade ago, you must have done much advanced way now. Please let me know. I am just doing it now. All indexes are in place for joining with other tables. Created View. Selecting from view.
Since view is a compiled version, it is relatively quicker than table.