Re: Choosing between 8i Standard and Enterprise?

alter index rebuild is available in Oracle 7 Workgroup, so I can't imagine it being dropped from 8 Standard.

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:950900402.12527.0.pluto.d4ee154e_at_news.demon.nl...
> Answers embedded
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Malcolm Dunnett <dunnett_at_mala.bc.ca> wrote in message
> news:iRco+3rdYf30_at_malvm2.mala.bc.ca...
> >
> > I'm trying to understand the difference between Oracle 8i
> > "Standard" and "Enterprise" editions. A lot of the differences
> > are obvious ( such as bitmap indices ) but I have a couple of
> > questions:
> >
> > 1.) A datasheet I've seen says "Online index build" is only
> > available in the Enterprise edition. What does this
> > feature mean? Does this affect ones ability to do
> > CREATE INDEX and DROP INDEX commands while the database
> > is being used?
> >
> Most likely the absence of ALTER INDEX REBUILD, which means a single step
> rebuild in situ
>
> > 2.) Given identical databases and computer setups are there
> > performance difference between Enterprise and Standard
> > edition ( eg does Enterprise cache things any better or
> > allow larger SGAs, etc ).
> >
> No
>
> > 3.) If one is dealing with a database that has a thousand or
> > so tables in total, with the largest tables having a couple
> > of million rows ( total database size of 5-10GB ) and all
> > access will be via SQLNet ( OCI and ODBC) is there
> > any compelling reason to use Enterprise edition vs Standard?
> >
> the only two options that could come in handy are the partition option and
> the parallel query option.
> With a total size of 5-10G I would want to have them.
>
>
>
Received on Fri Feb 18 2000 - 13:19:59 CST