Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Speed executing
> 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.)
I can't help you wit this, but what I can say, your query won't run at all, if you'd remove the last 256M of mem from your system.
Tanel. Received on Mon Mar 24 2003 - 03:22:30 CST