what does fragments: 0 vs. fragments: 1 mean ?
On 3rd Dec 1997 mcollins@us.dhl.com (Mark Collins) wrote:- This indicates that only one fragment will be searched in executing this query. If it required multiple fragments, you would see something like “fragments: ALL” or “fragments: 0,1”. The number of the fragment that will be searched is 0 in the first case, 1 in the second case. Fragment numbers are determined by the order in which the fragmentation expression is specified. In other words, rows that satisfy the first expression are placed in fragment 0, the second expression in fragment 1, and so on.
