Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Choosing between 8i Standard and Enterprise?
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? 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 ). 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?Received on Fri Feb 18 2000 - 10:24:31 CST