Hi Lynn, Does this book explains about creating indexes for the tables and the usage of the indexes? Also about having multiple indexes for a same table?
Thuwa, it's a bit light on that. While it goes into depth about Primary and Foreign Keys, and synthetic versus natural keys, I didn't get into indexing as much as I wanted to. There are probably better choices out there if that's the one topic you need to learn.
Lynn Beighley<br />Author, Head First SQL
These are not the droids you are looking for. Perhaps I can interest you in a tiny ad?
Free, earth friendly heat - from the CodeRanch trailboss