> Hello, > > ok, I guess I need to create a DESC index on TIMESTAMP of MY_TABLE. > I could verify this speeds it up from 1 minute to 1 second. > This works as long as MY_TABLE is a real table. > But now MY_TABLE is actually a View. > > Can I created a index on a view with firebird?
No, but an index on the underlying table should be used by the optimizer. Check the execution plan of your query accessing the view. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.