OraFAQ Forum: Server Administration » Indexes, what else could be the reason

Home » RDBMS Server » Server Administration » Indexes, what else could be the reason

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Indexes, what else could be the reason [message #60474]

Tue, 10 February 2004 05:27

Kapil
Messages: 145
Registered: May 2002

Senior Member

I am using a function based index to triming a col,

say TRIM(COL1) in one of my funtions. and i use this function in my sql loader scripts, this just use to Rocks.. i mean use to load data in no time becoz�optimizer was using funtion based index on that col. i haven't any changes to the scripts but optimizer doesn't use that function based index any more.

Yes, I do have query_rewrite_enabled and query_rewrite_integrity 'TRUE' and 'TRUSTED' respectively. i did do the analyze table and compute statistics on it. what else could be the reason.

thanks for taking my question

Report message to a moderator

Previous Topic:	Problem with open cursors
Next Topic:	never mind my below question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 22:05:58 CST 2025