Oracle 8.1.7 and on another server Oracle 9.2
Thanks,
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.
----------------------------------------------------------------------------------------
ksuh
@shaw.ca
06/04/2003 09:42 AM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: Re: OT: Table indexes
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
