my PL/SQL procedure is very slow.

From: <leirace_at_my-dejanews.com>
Date: Wed, 17 Jun 1998 11:30:44 GMT
Message-ID: <6m89d5$tsa$1@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 - 06:30:44 CDT