INTERVIEW QUESTIONS DATABASE FIREBIRD DETAILS

Question: How to recreate the index on a Firebird table?

Answer: Recreating the index:

ALTER INDEX indexName INACTIVE;
ALTER INDEX indexName ACTIVE;

Please note that it does not work for indices automatically created by the system like the ones for primary key or foreign key. You might want to drop and recreate the constraints in such case.

To recalculate the index statistics (which is enough for most cases), use:

SET STATISTICS INDEX indexName;

Recreating the index:

ALTER INDEX indexName INACTIVE;
ALTER INDEX indexName ACTIVE;

Please note that it does not work for indices automatically created by the system like the ones for primary key or foreign key. You might want to drop and recreate the constraints in such case.

To recalculate the index statistics (which is enough for most cases), use:

SET STATISTICS INDEX indexName; Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question