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: optimal sql

Re: optimal sql

From: Brian E Dick <bdick_at_cox.net>
Date: Mon, 09 Dec 2002 16:07:51 GMT
Message-ID: <rd3J9.17619$we.1152943@news2.east.cox.net>


With a test database that size you and/or your dba are going to be busy people once you go production. Try to get a test database that more closely represents the production database.

"Christoph Seidel" <chris666.seidel_at_gmx.de> wrote in message news:at2296$100u9l$1_at_ID-143718.news.dfncis.de...
> Peter van Rijn wrote:
>
> > It partly depends on how big your tables are. It may also depend on
> > Oracle version.
> > It is quite easy to test their effectiveness by just doing some
> > testing yourself.
>
> about 2 million rows each table on ora 8i
> but i cannot test it now, my test environ has a few rows only, that's why
i
> asked here
>
>
Received on Mon Dec 09 2002 - 10:07:51 CST

Original text of this message

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