Home |
Previous Page | Next Page Appendix B. How SQL Queries Are Executed > When Parallel Processing Occurs >
Operations Always Performed in Parallel
The following database operations are executed in parallel
when the database server has more than one CPU and the accessed
tables are fragmented into separate dbspaces:
- DSS queries
- INSERT, DELETE,
and UPDATE statements that process data
that is not on the connection coserver
- Sorts
- Index builds
- Update statistics
- onutil CHECK TABLE DATA and CHECK INDEX command
options
- Uncorrelated subqueries
The following sections describe how the database server uses
parallel processing to execute these database operations.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]