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

Joey on SQL Server Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization Reduce workload times with this handy feature that can benefit every database pro.

By nesting query filters you can create more complex filter conditions than by combining you to create more complex filter conditions than is possible when you combine filters at the same level.