| Subject | Re: [IBO] IBOStatisticalService: How to get all the detailed Index information? |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-11-22T14:15:22Z |
At 11:53 PM 22/11/2004 +1030, you wrote:
database. In an older database, the indexes created for UNIQUE constraints
typically have names like "RDB$11" (which is a UNIQUE constraint on
Project.Proj_Name in the Employee database, if you want to give that one a
try), regardless of whether you named the constraint or not.
In a Firebird 1.5 database, the index on a UNIQUE constraint will have the
same name as the constraint, if you make it a named constraint; or you can
provide a specific name with a USING clause.
Helen
>There are many UNIQUE indexes, i.e. not input as INDEXes but as UNIQUEThey do here. Perhaps the index names are hard to recognise in your
>statements. These do not appear. Is this a bug or as designed?
database. In an older database, the indexes created for UNIQUE constraints
typically have names like "RDB$11" (which is a UNIQUE constraint on
Project.Proj_Name in the Employee database, if you want to give that one a
try), regardless of whether you named the constraint or not.
In a Firebird 1.5 database, the index on a UNIQUE constraint will have the
same name as the constraint, if you make it a named constraint; or you can
provide a specific name with a USING clause.
Helen