Home » RDBMS Server » Server Administration » indexes
indexes [message #58991] Mon, 20 October 2003 13:47 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
I was tyring to create a function based index on to_date(col,' mm-dd-yyy') to tune a sql that has 4 table joins and where clause has this to(col1, 'mm-dd-yyyy') so i was trying to create a function based index on it, but its not alowing me to do so, so how do i do it.
Re: indexes [message #58993 is a reply to message #58991] Mon, 20 October 2003 14:40 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Check this out..

Previous Topic: Block Contention
Next Topic: Change permanent tablespace to temporary
Goto Forum:
  


Current Time: Sat Jan 04 22:27:45 CST 2025