Great article to get started with optimizing queries/indexes.

Have you ever used JOINS on hash indexes in your work? Do you recommend such an approach?