4 ms·
"the on-disk overhead of a SQL database is fairly limited" The ___minimum___ on-disk overhead... At run time after deployment after growth sometimes I have to
by VLM 14y ago
"the on-disk overhead of a SQL database is fairly limited"
The ___minimum___ on-disk overhead...
At run time after deployment after growth sometimes I have to scramble adding indexes and depending on the business demand for "instant" online reporting or query speed, you can end up with a ridiculous number of large indexes. Which also has a negative, hopefully survivable effect on insert/update/delete speeds. I guess I'd add:
* tunability - the DBA decides at the DB level based on defined business requirements how to trade disk space for read speed.