Northwinds is a great database for testing, but it is rather small. Here’s a great way to create a view that contains about 40 million cells on 2.5 million records. It’s a great way to test on a large data set:
[sql]ALTER VIEW OrdersSquared AS SELECT Orders.* FROM Orders CROSS JOIN ORDERS O2[/sql]
Ready to learn more? Get a live demo with an Izenda product expert.