Xref: alice comp.databases.oracle.server:30140
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!nyd.news.ans.net!abq.news.ans.net!abq.news.ans.net!news-w.ans.net!newsfeeds.ans.net!news-w.ans.net!swweb.sherwin.com!mtravis@ccgate.sherwin.com
From: "Craig A.Miller" <CAMiller@sherwin.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: index and ADT
Date: 29 Sep 1998 19:09:54 GMT
Organization: COMSYS
Lines: 15
Message-ID: <01bdebdd$62fba280$837e8d94@K980.sherwin.com>
References: <360F7F43.C365C9DF@ceram.fr>
X-Newsreader: Microsoft Internet News 4.70.1161

I was browsing through Oracle8: The complete reference by G. Koch and K.
Loney and I remember seeing your solution. You'll find it on page 617.

Accordingly, you should specify the full path of the column you wish to
index, not the column that is ADT.

Per your example:

create index rectangle_index on rectangle(figure.width, figure.Longr);

If you don't have the book, you should seriously consider the purchase. 
The book is a good one; expensive, but good.



