5.12 Considerations when searching an archivable multi-chunk table

This section explains the matters you need to consider when searching an archivable multi-chunk table.

The examples in this section use a table in which the archive range column contains datetime data in DATE format.

Note

Make sure that you read Chunk archiving function (compressing data in a chunk) in the HADB Setup and Operation Guide before reading this section.

Organization of this section

• 5.12.1 Tips for searching an archivable multi-chunk table

• 5.12.2 Using the datetime information of the archive range column to narrow the search range

• 5.12.3 Notes about specifying JOIN (joined table)

• 5.12.4 Equivalent exchange of SQL statements that search archivable multi-chunk tables

To Page Top