Toad World® Forums

How can I make random stream queries for TPC-H test?

I learned stream for TPC-H is consists of 22 queries.

And I created data and queries by dbgen and qgen. But there is no information about how to randomly order the queries.

Are there any tool or options for this? or Should I order the queries by manually?

You can change the order of the queries in the steam by right-clicking on a query and then selecting Move Up or Move Down. The order that they are in by default corresponds the specification for the TPC-H Power Test.