--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Test was run on Windows 2003, P4 2.8GHz, FirebirdSql 1.5RC7
> > Database contains 20,283 rows
> >
> > Query Time
> > ------------------------------------------------
> > Prepare : 15
> > Execute : 172
> > Avg fetch time: 172.00 ms
> >
> > Memory
> > ------------------------------------------------
> > Current: 1,099,248
> > Max : 1,196,224
> > Buffers: 2,048
> >
> > Operations
> > ------------------------------------------------
> > Read : 7,313
> > Writes : 4
> > Fetches: 136,397
> >
> > Plan:
> > ------------------------------------------------
> > PLAN (ABNTRADEDATA NATURAL)
> > PLAN (ABNTRADEDATA NATURAL)
> > PLAN (ABNTRADEDATA NATURAL)
> > PLAN (RDB$DATABASE NATURAL)
> >
> > Enchanced Info:
> > +--------------------------+-------+-----------+---------+--------
> > -+----------+
> > | Table Name | Index | Non-Index | Updated | Deleted |
> > Inserted |
> > | | reads | reads | | |
> > |
> > +--------------------------+-------+-----------+---------+--------
> > -+----------+
> > | RDB$FIELDS| 13 | 0 | 0 | 0 |
> > 0 |
> > | RDB$INDEX_SEGMENTS| 1 | 0 | 0 | 0 |
> > 0 |
> > | RDB$RELATION_FIELDS| 13 | 0 | 0 | 0 |
> > 0 |
> > | RDB$RELATIONS| 2 | 0 | 0 | 0 |
> > 0 |
> > | RDB$RELATION_CONSTRAINTS| 1 | 0 | 0 | 0 |
> > 0 |
> > | RDB$DATABASE| 0 | 1 | 0 | 0 |
> > 0 |
> > | ABNTRADEDATA| 0 | 60,849 | 0 | 0 |
> > 0 |
> > +--------------------------+-------+-----------+---------+--------
> > -+----------+
> >
> >
> >
> >
> >
> > Query Time
> > ------------------------------------------------
> > Prepare : 15
> > Execute : 94
> > Avg fetch time: 94.00 ms
> >
> > Memory
> > ------------------------------------------------
> > Current: 1,065,624
> > Max : 1,196,224
> > Buffers: 2,048
> >
> > Operations
> > ------------------------------------------------
> > Read : 4,865
> > Writes : 4
> > Fetches: 90,887
> >
> > Plan:
> > ------------------------------------------------
>
>
> What was the plan for the SP?

hmmmm ... it is not available