Opened 15 years ago
Closed 14 years ago
#535 closed enhancement (fixed)
RDBMS: More efficient index retrieval
| Reported by: | brentrobinson | Owned by: | brentrobinson |
|---|---|---|---|
| Priority: | minor | Milestone: | 3.5.0 |
| Component: | FDO API | Version: | 3.5.0 |
| Severity: | 3 | Keywords: | RDBMS Schema Manager index performance |
| Cc: | External ID: |
Description
When indexes are fetched for a batch of database objects at a time, objects that don't have indexes (e.g. synonyms) are included in the batch. Weeding out these objects reduces the number of select executions that need to be done.
Change History (3)
comment:1 by , 15 years ago
| Status: | new → assigned |
|---|
comment:2 by , 15 years ago
comment:3 by , 14 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
Revision: 5042 Author: brentrobinson Date: 1:08:33 PM, Friday, October 23, 2009 Message: Ticket#535: When a index select retrieves no indexes, mark all selected tables and views as having indexes loaded. Previously, objects without indexes were only marked of some indexes were retrieved.
Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/DbObjectComponentLoader.h