Noel J. Bergman wrote:
MSSQL def. works that way, we're pretty sure Oracle does as well, and I would guess any other commercial server would. Can't speak for hypersonic or postgresql. If all we're changing is the ordering of an index/key, I would say make the change as I can't see it breaking anything. Then as needed, the various db users can test and submit a patch to create the second index if their DB needs it.The goal of this is to speed-up queries with a WHERE statement that specifies only the repository_name, correct?Yes. Are you agreeing with Dan Rollo that most servers should work the same way that MySQL works, where we can just optimize the order of a multiple column index instead of creating another index? Are you confirming that MSSQL works that way? I've made that change here. If the consensus is that it is effective on enough systems, I'll commit it and mark off that item from the project list.
--
Serge Knystautas
Loki Technologies
http://www.lokitech.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
