SQL SERVER 2K

We have 30 databases each for one business units.
Now I am consolidating few tables from 30 databases to one database for
Analysis purpose.

Now my tables in Central db have millions of records.
I need some tips to handle this huge tables for query purpose (already
applied with all Indexes).

Can I go with INDEXED VIEWS ??

Thx
Sh