Hi!

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

30 indices. And they all are useful? How selective are they?

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

Take an eye on the execution plan, I/O stats in the monitoring table or
via the trace api.

Btw, you know that with the usage of FIRST above, you probably won't get
your expected result?

You probably want to do:

select first 200 skip 0 ... from (
select ... from order by c, d
)

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

Things are getting more complicated with several tables IMHO. So if you
don't have a strong reason e.g. maintenance or performance wise, go with
one table.

Basically, Firebird can handle tables with 20 millions records. It
vastly depends on how optimized the access is.

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

Sorry, I don't understand this question.



--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

> thanks for your help
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>