The schedule level for a query indicates its relative importance. The effect of a schedule-level value depends on the schedule levels of the other queries that are waiting for execution. If all queries have the same schedule level, the admission policy and the amount of memory available determine when the query can run.
Use the SQL statement SET SCHEDULE LEVEL to set the scheduling level for a query. The default scheduling level is 50. The higher the value, the higher the schedule level.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]