Determine when to skip selected fragments

In certain circumstances, you might want the database server to skip some fragments, but not others. This usually occurs in the following situations:
  • Fragments can be skipped because they do not contribute significantly to a query result.
  • Certain fragments are down, and you decide that skipping these fragments and returning a limited amount of data is preferable to canceling a query.

When you want to skip fragments, use the ON dbspace-list setting to specify a list of dbspaces with the fragments that the database server must skip.

Copyright© 2018 HCL Technologies Limited