Re: my PL/SQL procedure is very slow.

Try it with an index - that should help, I think.

create unique index myindex (input_name) /

Leave out 'unique' if your index isn't unique. --
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

leirace_at_my-dejanews.com wrote in article <6m89d5$tsa$1_at_nnrp1.dejanews.com>...
> hi all:
> I'm a newbie of oracle pl/sql.
> I use a cursor in a procedure, It' select one or more record
> from a large table, like this
>
> "select name,address,email from my_table where name like
> input_name||'%';"
>
>
> But the table is so large, my procedure need about 1 minutes.
> if I use :
> "select name,address,email from my_table where
name=input_name;"
>
> only need about 4 second, but I can't get more record like input name.
>
> I didn't create index on this table, I want to know how create the index
> that I can improve the speed of my procedure.
> Can I improve the speed that my procedure only take 10 second use
"like"
> and get more record ?
> thank you very much!
> leirace
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Wed Jun 17 1998 - 15:17:59 CDT