Controlling query processing

Any user can set limits on the amount of time spent processing a particular query. Users with DBA privileges can give certain users’ queries priority over others, or change processing algorithms to influence the speed of query processing. See Reference: Statements and Options for details on the options described in this section.