Thomas, What can you expect if Firebird needs temporary disk space which isn't > available to create/activate an index? >
I expect the statement to fail but but not corrupt the state of the database. Similarly to how a query with a large sort would fail if there is not enough disk space for the temporary sort file and doesn't corrupt the database. Thanks, Alec [Non-text portions of this message have been removed]