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 ...

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

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 ...