File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes HFSQL - Creating Indexes? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "HFSQL - Creating Indexes?" Watch "HFSQL - Creating Indexes?" New topic

HFSQL - Creating Indexes?

Thuwaragan Sundaramoorthy

Joined: Jan 11, 2007
Posts: 26
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?

thank you.

Best Regards,

------------------------------<br />SCJP 1.5
Lynn Beighley
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
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
I agree. Here's the link:
subject: HFSQL - Creating Indexes?
It's not a secret anymore!