Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Speed executing

Re: Speed executing

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 24 Mar 2003 11:22:30 +0200
Message-ID: <3e7ecd98$1_1@news.estpak.ee>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US