Another command in place of substr [message #38428] |
Wed, 17 April 2002 09:56 |
Vidyalakshmi Iyer
Messages: 13 Registered: April 2002
|
Junior Member |
|
|
Hi,
I have a cursor definition which uses substr in the where clause.
For eg
where name = substr(:varname,1,length(name))
I open and close this cursor 'many' times in a loop. Could that make it slow? and if it does...
Is there any other command which is faster and does the same job as substr?
Regards,
Vidya.
|
|
|
Re: Another command in place of substr [message #38431 is a reply to message #38428] |
Wed, 17 April 2002 10:35 |
Rick Cale
Messages: 111 Registered: February 2002
|
Senior Member |
|
|
Without knowing what you are doing it is difficult
to tell if it is necessary to open/close every time.
Open/close of a cursor is expensive but sometimes
you have to. If there are a lot records in this
table it could be slow due to the full table scan
you are probably doing. You may want to investigate
creating a function based index on name field.
|
|
|