A Simple Way to Test a Large Data Set

By August 8, 2011Tips

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.