Abstract: An approach is provided for improving query performance. A query is received whose execution includes a first join of tables having sets of records and includes a second join with a next table whose set of records is smaller than a set of transient records resulting from the first join. A threshold for a number of records in the next table is received. A first count of the transient records resulting from the first join is estimated. A second count of a number of records in the next table is determined. It is determined that the second count is less than the threshold. Based on the second count being less than the threshold and without using the first count, a query execution plan is generated to include a broadcast of the records in the next table to data slices without including a broadcast of the transient records.

Abstract: The indication of a database backup process starting is received. A plurality of buffer manipulator threads are marked as active. A determination is made whether any of the plurality of buffer manipulator threads marked as active in the database backup process become idle. In response to determining that at least one buffer manipulator thread in the database backup process becomes idle, the at least one idle buffer manipulator thread is reassigned to a first largest tablespace in the database that has not completed the database backup process. The first largest tablespace has a largest storage capacity relative to other tablespaces in the database.

Abstract: The indication of a database backup process starting is received. A plurality of buffer manipulator threads are marked as active. A determination is made whether any of the plurality of buffer manipulator threads marked as active in the database backup process become idle. In response to determining that at least one buffer manipulator thread in the database backup process becomes idle, the at least one idle buffer manipulator thread is reassigned to a first largest tablespace in the database that has not completed the database backup process. The first largest tablespace has a largest storage capacity relative to other tablespaces in the database.