I never really knew until today. Tim Bunce's Programming the Perl DBI (somewhat dated - I haven't checked the latest docs) doesn't say much on the subject other than, "don't use them if your vendor doesn't support them (duh)".
Here's where Guy Harrison's book has enlightened me yet again. The answer? Histograms.