title: How can I predict the resources needed to complete SQL request under given DB structure and given table sizes?
body: <p>I understand that the measurement of the resources needed for any calculation is very relative and depends on:</p>
  
  <ul>
  <li><p>hardware configuration,</p></li>
  <li><p>software settings,</p></li>
  <li><p>methodology after all.</p></li>
  </ul>
  
  <p>But anyway if I want to develop a web application which using a database I will definitely need to create DB structure intelligently.</p>
  
  <p>Of course there is a theory which can tell us how exactly DB engine work under given circumstances. But I expect that the circumstance list will be too complex: type of storage engine, hardware configuration and so on...</p>
  
  <p>I'd really like to be able to set up an empty DB and find out how many CPU 'ticks', IOs and memory would be used if the affected tables would have the given amount of rows.</p>
  
  <p>Is there any way to do it?</p>