>Only problem with that is if you are accessing a table with a lot of >rows, Oracle ends up doing its upper function on the entire column >which can slow things down a bit when running the query.
Look into function based indexes to solve this. Buy the book "Expert one-on-one Oracle" by Tom Kyte (Wrox/Apress) if you want to unlock the more powerful features of Oracle (but it should not be your first Oracle book obviously). If your customer is paying all that money for an Oracle license, you should be looking at maximizing their return. just my 0.02$, /t >-----Original Message----- >From: Aaron Rouse [mailto:[EMAIL PROTECTED] >Sent: Friday, January 07, 2005 3:30 PM >To: CF-Talk >Subject: Re: CF - switching from MS-SQL to Oracle (neq Neo, >Morpheus, Trin ity) > >One thing to keep in mind is Oracle is case sensitive where if I >remember right MSSQL is not? So something like WHERE BLAH = 'foo' >returns something different than WHERE BLAH = 'FoO' I know some >people just do oracles upper function on the BLAH in order to get >around this, then of course a CF's upper function on the other side. >Only problem with that is if you are accessing a table with a lot of >rows, Oracle ends up doing its upper function on the entire column >which can slow things down a bit when running the query. > >-- >Aaron Rouse >http://www.happyhacker.com/ > >On Fri, 7 Jan 2005 14:19:40 -0000, Robertson-Ravo, Neil (RX) ><[EMAIL PROTECTED]> wrote: >> Your queries should be AOK...as long as you are not using any Oracle >> Specific SQL commands......though really apart from some >quirky join syntax >> you should all be good. >> >> If you are simply sticking to Insert, delete etc. >> >> -----Original Message----- >> From: Stuart Kidd [mailto:[EMAIL PROTECTED] >> Sent: 07 January 2005 14:14 >> To: CF-Talk >> Subject: CF - switching from MS-SQL to Oracle (neq Neo, >Morpheus, Trinity) >> >> Hi guys, >> >> I'm about to start on a new project at my current contract >for which i've >> had them buy CF (and for once i didn't take too much convincing). >> >> In the past (and present) I connect to an MS-SQL database >which i've grown >> to love. >> >> At work however, it's all Oracle. I've connected it using the CF >> Administrator and am using TOAD to add tables etc. >> >> Before i start coding i'm wondering if my CFQUERYies will be >different to >> those I have created for MS-SQL in anyway? >> >> Thanks for your help, >> >> Stu >> >> ps: also, does anyone know how to create an incremental >number for an INT in >> TOAD (it's for an PK id)? >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189643 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
