How to activate all indexes in Firebird?
Submitted by: AdministratorIf you run Firebird 1.x which doesn't have EXECUTE BLOCK, you can run the following query:
select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where rdb$system_flag is not null and rdb$system_flag = 0
Submitted by: Administrator
select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where rdb$system_flag is not null and rdb$system_flag = 0
Submitted by: Administrator
Read Online Firebird Job Interview Questions And Answers
Top Firebird Questions
| ☺ | How to detect the server version? |
| ☺ | How to write UDF s in Delphi? |
| ☺ | How do convert or display the date or time as string? |
| ☺ | How to drop all foreign keys in database? |
| ☺ | Is there some bulk load or other way to import a lot of data fast? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
