sqlsmith | A random SQL query generator | SQL Database library

"I do not know from what random place people will want to travel to a random other place, so instead, let's create roads for every possible combination of origin and destination".

That sounds kind of insane, doesn't it? The same applies to what you seem to be wanting to achieve. You basically are hoping to find a tool that generates random queries against your database so you can feed them to the tuning advisor, which will then suggest query optimization indexes for hypothetical queries.

If you want to performance tune your database, you should have a pretty good idea of the type of questions your users will be throwing at it, as well as the structure of your data. Typical questions that will help you get started would be things like:

• What is the most common search my users would do against this table?
• What criteria are they most likely to use?
• Which columns are guaranteed or likely to contain unique data in every row?
• Which columns will most likely have a low selectivity of data? (I.e. Male/Female)