I am breaking the table. From what I read, SQL will use sections as needed based on query predicates.
For example, if I have a section for records in the period from 2005 to 2009, and another for records of 2010 is the current one and I select = 2010 for all records, SQL will ignore the first section due to the function of the section. If I am looking for a record between 2008-2010, SQL will use both sections, but do it in parallel. Is it right to assume that if I query ALL records without a predicate, this SQL will (as much as possible) use all sections in parallel?
When do table sections cause bottle roughness?
source
share