It depends in the DB you're using. ----- Original Message ----- From: Casey C Cook <[EMAIL PROTECTED]> Date: Wednesday, June 4, 2003 10:38 am Subject: OT: Table indexes
> Hello - > > Is this a true statment? > > There was an index on SFC_PART_SERIAL_REFERENCE(PART_NO) so I > dropped it > and added the index on SFC_PART_SERIAL_REFERENCE(PART_NO, > SERIAL_NO). Any > query that was using the old index should be able to use the high > order > portion of the new index. > > If I run a query on PART_NO alone, will it use the > part_no/serial_no > index, I didnt think that was the way indexes worked, but I have > been > wrong many times. Is there a good reference to read exactly how > indexes > work? > > Thanks for your input, > CC > ------------------------------------------------------------------- > --------------------- > This is a PRIVATE message. If you are not the intended recipient, > please > delete without copying and kindly advise us by e-mail of the > mistake in > delivery. NOTE: Regardless of content, this e-mail shall not > operate to > bind CSC to any order or other contract unless pursuant to > explicit > written agreement or government initiative expressly permitting > the use of > e-mail for such purpose. > ------------------------------------------------------------------- > --------------------- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
