Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Abstract DataType ??
fhashmat_at_yahoo.com (Fahim) wrote in message news:<62f7c5ff.0211211233.5485ef18_at_posting.google.com>...
> Hi,
> I am in the middle of designing a report server (demoralized form of
> production), and want a suggestion, I have a table which could grow
> upto 2.5 to 3 million rows, Is it a good idea to make several abstract
> data type, like Name_TY(First, Last, Mi) Bill_Add_TY(Add1,Add2),
> Ship_Add_TY(Add1,Add2) etc in one table or create one table with all
> of these columns prefix with main demog like NAME_FIRST, NAME_LAST,
> MAIL_ADD_ADD1, SHIP_ADD_ADD1 etc.
>
> Which would be most efficient in performance, where would data
> actually store in abstract type column, is it store out side the table
> or in the table. if it store outside the table (like nested table)
> then I think second option would be best for me.
In terms of performance, I'm under the impression that any fancy, object-oriented data type causes a drop instead of boost in performance. It may make developer's code look prettier, if not cleaner.
In this newsgroup, Jonathan Lewis may be the best person to answer the storage question. Or you can read his book.
Yong Huang Received on Fri Nov 22 2002 - 13:56:50 CST