Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: index and ADT
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. Received on Tue Sep 29 1998 - 14:09:54 CDT