Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Speed executing
Hi
Before pointing on the hardware
you have to determine the cause of your
slow query
No one know what it will give
with extra hardware but everyone
know that your performance
will increase considerably
if you add an index on the column "Name"
hth
Chris
"mm" <meisinger_co_at_hotmail.com> wrote in message news:<b5mgef$2rr0$1_at_as201.hinet.hr>...
> For Jim Kennedy
>
>
> For example:
>
> 1. Case
> Query select * from product where name like 'PER%'
>
> machine 1GHz, NT 4.0, 256 MB RAM
> rows 500000
> time exec. 6 s
>
> 2. Case
> Query select * from product where name like 'PER%'
>
> machine 2x500 MHz, NT 4.0, 1 GB RAM
> rows 500000
> time exec. ???? (appr.)
>
> Thanks Jim
Received on Mon Mar 24 2003 - 07:25:25 CST