How to activate all indexes in firebird?
Answer / Gaurav Nidhar
To activate all indexes on a Firebird table, you can use the MONITOR_ACTIVE statement. Here is an example:nnSET TERMINATOR ^;.nMONITOR_ACTIVE ALL FOR TABLE <table_name> ACTIVATE;
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the applications of database management system?
what is the difference between unique and primary key
Define primary and unique key?
How to open the database in exclusive mode?
What are the steps involved in Instance Recovery ?
What does fill factor concept mean with respect to indexes?
How do you backup a database?
Explain about the case statement present in stored procedure?
How to create a database from my program?
Which database is best for large data?
What's the difference between star and snow flake schema?
Explain about User_Defined Exceptions?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)