You really need to read about partitioning. There are several types of partitioned indexes and only the application can dictate which one is best. Try ( [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c09parti.htm#429785[/url] ) for a start.

The previous example creates and maintains the same number of partitions as the base table.