Hot answers tagged partitioning
You should be fine; the rowid would be a show-stopper if you were using it Temporarily, there would be "holes" in the data files, but Oracle will fill them in without any intervention. Ensure you have automatic tablespace management enabled. You can invoke that command but no need to; let Oracle take care of it The person that stated that probably meant ...
To get partition elimination, your queries need to be explicit about the bit data type, for example: ...WHERE Archivable = CONVERT(bit, 0) -- NOT ...WHERE Archivable = 0 Without this, the risk of truncation in the implicit conversion means partition elimination is not applied. The implicit conversion in the CREATE PARTITION FUNCTION statement is not a ...
I suspect this is more to do with the data type of AcctYear (DECIMAL(4,0)). When you simply specify WHERE AcctYear = 2014 SQL Server (in my test rig) believes this to be a SMALLINT. You can see this with a few trace flags: Effective partition elimination relies on data types lining up (amongst other things). Workarounds include changing the datatype of ...
Postgres-XL is attempting to solve this as of 2014. They're aiming directly at big data on PostgreSQL, and they have developers from Stado onboard.
Only top voted, non community-wiki answers of a minimum length are eligible