Hello! Is there any practical limit to use union? I mean may I use union to mix
two tables with 5000 records each and order the result by some date field?

I'm testing it with the biggest tables I have at the moment, and it seems to be
quite fast... Of course, this select has no sence, it's just for a test...

select ID,descripcion from STOCK

union ALL

select id,razon_social from proveedores

order by 1

This are the statics FlameRobin reports, but unfortunatelly I don't know how to
interpret them...


Starting transaction...
Preparing query: select ID,descripcion from STOCK

union ALL

select id,razon_social from proveedores

order by 1


Prepare time: 00:00:00.
Field #01: STOCK.ID Alias:ID Type:INTEGER
Field #02: STOCK.DESCRIPCION Alias:DESCRIPCION Type:STRING(150)
PLAN (STOCK NATURAL)
PLAN (PROVEEDORES NATURAL)


Executing...
Done.
79055 fetches, 4 marks, 0 reads, 4 writes.
0 inserts, 0 updates, 0 deletes, 371 index, 37341 seq.
Delta memory: 9519800 bytes.
Execute time: 00:00:00.