Function Based indexes in 10g. Anybody know if there is more to activating function based indexes in 10g. Not sure if till need the rewrite parameters 1. create the function based indexes 2. analyze the table and indexes 3.QUERY_REWRITE_ENABLED=TRUE QUERY_REWRITE_INTEGRITY=TRUSTED 2 indexes 1 based on a trim(column) 1 based on a trunc(column) Back in my mind, I thought there was something else to do to activate the QUERY_REWRITE_ENABLED. anyone esle share their fun getting these functional indexes to be activated in the explain plan? Thanks brian ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kevin Closson Sent: Wednesday, December 14, 2005 11:36 AM To: Oracle-L Subject: RE: Lets load test SAN, DAS or NAS ? ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ethan Post Sent: Wednesday, December 14, 2005 8:13 AM To: kutrovsky.oracle@xxxxxxxxx Cc: oracle-l Subject: Re: Lets load test I have a benchmark script I would like you to try, will send you the attachment in a seperate email. Be interested in seeing the numbers, it is very easy to run. I will post the script on the web when I get a chance for everyone. -Ethan On 12/14/05, Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx> wrote: I have a relativelly fast machine for testing. It's a 4 cpu XEON 3.6 ghz with 1 mb of cache 16 gb of ram and a lot of fast storage. It's running RedHat linux 4 64 bit with 64 bit Oracle 10g and ASM. Throw your ideas if you would like to see something tested, it's sitting idle right now. I just finished setting it up, so i am running some very raw tests. For example, I created a 3.68 gb table with ~40m rows from dba_objects. Exact size is: 3'959'422'976 bytes 38'653'952 rows It's gething full scanned for 5.05 cpuseconds. (482008 logical reads, no physical). If anyone wants to see something let me know. There's 500 gb of storage available. -- Christo Kutrovsky Senior Database/System Administrator The Pythian Group -- //www.freelists.org/webpage/oracle-l