Toad World® Forums

Benchmark with "parameterized"queries


Are there any sample/tutorial custom benchmarks with parameterized queries where Benchmark Factory supplies various values at execution time? I see where you can edit and create a SQL statement - and then use $BFDate to generate a date between 2 values. But wanted some samples/examples of the possiblities for using things like $BFCountry() or $BFRandRange() - or know what else I could do(is there any way to restrict dates to quarters 1/1, 4/1, 7/1, 10,1 …


There are several examples of the use of BFScripts in the help file. Take a look and see if you can build a BFScript to accomplish what you need. Remember BFScripts can be inside other BFScripts.