title: Disadvantages of table partitioning (e.g. SQL Server)
body: <p>I have never partitioned a table, however from what I have read it has many advantage in terms of querying and archiving data. </p>
  
  <p>Is it superior to creating indexes? Are there any disadvantages? Is the time spent on partitioning the only cost? </p>