>I am actually not using any indexes, just the raw tables. This may seem

strange for working with alot of data but the idea is >to try and bring
Firebird to it's knees.

I'd say you succeeded.

So, what's your point?

>The time difference seems to be far to much for it to be an issue with

indexing( less than 1 second with AND and 12-17 seconds with OR).


Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com