Few insert/update/delete transactions, read-only queries. |
Non-selective & data-intensive; few in number, large in size |
May return a large volume of data: e.g.: mailing list |
Queries frequently scan a large percentage of the data in the database |
Often used to mine data in a recursive, drill-down fashion |