| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
