| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Indexing techniques for hierarchies
> 1. Create 1,000 tables (ie T1, T2, ...)
> 2. Each record has five fields:
> (pk int32, p2 float64, p3 bool, p4 text255, p5 dateTime)
> (Would need additional field fk start from T2 to relate records)
> 3. Create one record in each table.
If they all have the same 'fields', why exactly would you not use a single table with 1000 rows??
Regards
Paul Vernon
Received on Mon Dec 24 2001 - 08:47:39 CST
![]() |
![]() |