martin.chantler@convergys.com writes:
> For storing character data such as surname, email address which
> is the best data type to use?
See FAQ item 4.15. VARCHAR is my suggestion.
> Can each of these be indexed???
Yes
> Which of these is fastest considering hard disks are so cheap I don't much care
> about which takes the most bytes!
You're dead wrong if you're thinking that way. The issue is not that hard
disk space is cheap, it's that cache memory is scarce.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
