Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: InterBase/Server/Performance    [ Add a report in this area ]  
Report #:  42798   Status: Reported
No index on table RDB$RELATION_CONSTRAINTS, field C.RDB$RELATION_NAME
Project:  InterBase Build #:  WI-V7.5.1.162
Version:    7.5 Submitted By:   Andrej Vidmar
Report Type:  Suggestion / Enhancement Request Date Reported:  3/19/2007 7:35:06 AM
Severity:    Commonly encountered problem Last Updated:
Platform:    All platforms Internal Tracking #:  
Resolution: None  Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
When searching for constraints in system table RDB$RELATION_CONSTRAINTS for a given table name no index is used, which hinders performance.
Steps to Reproduce:
1. Run IBConsole. Connect to any database (like employee.gdb example).

2. run query:

select *
from RDB$RELATION_CONSTRAINTS
where RDB$RELATION_NAME='MYTABLE'

and observe the execution plan. Natural acces to table RDB$RELATION_CONSTRAINTS is used
Workarounds
Create index manually on any new database.

create index RDB$INDEX_CUSTOM1 on RDB$RELATION_CONSTRAINTS (RDB$RELATION_NAME)
Attachment
None
Comments

None

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.