Since your trying to do it with SLOW ColdFusion, I would recommend you move it into a Oracle Stored procedure and run it that way then CF doesn't play any part in the actual querying of the data.
My 2 cents... Brad -----Original Message----- From: Brad Bueche [mailto:[email protected]] Sent: Thursday, January 15, 2009 9:31 AM To: sql Subject: Oracles "Partition" keyword I need to query a very large oracle database of network event traffic. I cant really do any sort of efficient query unless I can specifiy partition: SELECT * FROM reporter_db PARTITION (P200901) CF doesnt seem to recognize the "PARTITION (P200901)" Is there some special syntax I have to use to get it to recognize this? thanks brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3173 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
