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??

Although step 2 indicates the same field names in each table, they represent different fields. Think of it as local variables in different functions. Naming the fields the same in each table or even having the same number of fields in each table was an arbitrary decision to make the benchmark easier to create. Received on Tue Dec 25 2001 - 04:19:11 CET