IIRC most expensive RDBM's (Oracle, SQL server, DB/2) support nested tables in some form through UDTs.<BR><BR>I believe Oracle performs slightly worse with nested tables, but it can have some ...

When I finally unraveled the nested views, which had several unnecessary joins and columns, and wrote a plain query, the time for that same query dropped to subseconds. 3. Do use table-valued ...