Re: Oracle and small tables

Simply ask those that told you that to prove it.

We have one schema in one database with 8,349 tables. Largest table is .913 meg. Only PK and FK indexes. between 4 rows and 200,000 rows.

All look up information, multiple schemas join to those tables to perform the look ups. No performance problems in the database. Statspack report shows the longest elapsed time (cpu) for a query is 2.21 seconds. 94 executions a second.

Don't ask why it is this way - you don't want a rant on the groups :)

http://yaodba.blogspot.com Received on Sun Mar 12 2006 - 17:35:10 CST