And this is why you leave the design of databases to professionals. Note: this is before my morning cup of joe, and I'm shooting from the hip.
If you can't redesign their database schema outright, then what about views/materialized views and an index on the view. But the best choice would be to redesign the table structures to begin with. Now if you want to have some fun, write a new storage implementation for derby and then allow for data partitioning. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of David Van Couvering > Sent: Tuesday, February 20, 2007 5:49 PM > To: Derby Discussion > Subject: Database Anti-Pattern - clustering your own database > > http://thedailywtf.com/Articles/Roll_Your_Own_Clustered_Index.aspx
