Re: number of tables (173 Views)
Occasional Contributor
Posts: 2
Registered: ‎04-07-2005
Message 1 of 4 (173 Views)

number of tables

Please let me know,for a database size of 35GB, what will be the approximate number of tables
Occasional Visitor
Posts: 2
Registered: ‎04-16-2005
Message 2 of 4 (173 Views)

Re: number of tables


You will never get a right answer to this question and you already probably know why!

Honored Contributor
Posts: 830
Registered: ‎10-03-2000
Message 3 of 4 (173 Views)

Re: number of tables


I do not believe that there is a clear rule of thumb for IMAGE data sets to ORACLE or SQL tables. I could be wrong, but I've NEVER seen one.

Chuck Ciesinski
"Show me the $$$$$"
Frequent Advisor
Posts: 30
Registered: ‎07-12-2000
Message 4 of 4 (173 Views)

Re: number of tables

You cannot equate database size with number tables. That is dependent on your data model. There is a loose correlation between Image datasets & tables. I say loose for two reasons:

1) Performance issues moving from a networked hierarchical to relational model.

2) Data types & DBMS management overhead.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.