add index on nested table

A newbie's question. How oracle add an index on nested table. F.g.

Table Student:

    sid sname classes_registed{class_id, class_name}     01 marry {{c1, classA}, {c2,classB},{c3,classC}}

Can Oracle add index between sid and class_id, so that if a query give c1, c2, or c3, I can locat 01's whole tuple??

Thanks a lot. Received on Tue Sep 20 2005 - 16:53:25 CDT