How to activate all indexes in firebird?



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

Post New Answer

More Database Management Interview Questions

What are the applications of database management system?

1 Answers  


what is the difference between unique and primary key

5 Answers  


Define primary and unique key?

1 Answers  


How to open the database in exclusive mode?

1 Answers  


What are the steps involved in Instance Recovery ?

1 Answers   ibcs primax,


What does fill factor concept mean with respect to indexes?

1 Answers  


How do you backup a database?

1 Answers  


Explain about the case statement present in stored procedure?

1 Answers  


How to create a database from my program?

1 Answers  


Which database is best for large data?

1 Answers  


What's the difference between star and snow flake schema?

1 Answers  


Explain about User_Defined Exceptions?

1 Answers  


Categories