| Database Design |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Use
Indexes wisely |
||||||||||||||
| – | Don’t
use several indexes when one will do |
||||||||||||||
| – | Understand
the “leftmost prefix” rule |
||||||||||||||
| • | Index
on (col1, col2, col3) vs. 3 indexes |
||||||||||||||
| – | Don’t
index columns until you need to |
||||||||||||||
| – | Verify
that indexes are used (difficult) |
||||||||||||||
| – | Use
partial indexes on large (text) fields |
||||||||||||||
| – | Index
a hash rather than a large value (URL) |
||||||||||||||
| • | MD5
is an excellent choice |
||||||||||||||
| • | It’s even
built-in |
||||||||||||||
| Copyright
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |