[firebird-support] What the best big table or several small table

[Vander Clock Stephane]

Hello,

i have one table with lot of index (around 30, record around 20 millions)

We access the data only throught query like

select First 200 skip 0 .... from MyTable where c = XY and d = zw and A 
 > x and b < Z ... ORDERBY C, D

what is the best :

1/ One table with lot of record ?
2/ Several tables with fewer records ?

because i can split easyly the number of row in 10 differents tables

also is an empty on not very used table use firebird ressource ?

thanks for your help