> Run stadistic for database > - Look for index in de big tables. Look for Depth > 2. In this case > up Page size one step, and run database statistical.
>2 is quite conservative these days with the available hardware resources and even with a 16K page size you may reach that threshold with indexes on moderate sized tables rather quickly. Everything <=3 is just fine. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.