| Subject | Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results |
|---|---|
| Author | |
| Post date | 2019-02-28T05:54:40Z |
---In firebird-support@yahoogroups.com, <tultalk@...> wrote :
On 2/27/2019 2:44 PM, Robert Tulloch
tultalk@... [firebird-support] wrote:
Hi:
I just ran this
select 'MEMPAY1' AS TABLE_NAME, 'M1ID' AS INDEX_NAME, cast(RDB$STATISTICS as varchar(32)) as RDB$STATISTICS from rdb$indices where RDB$SYSTEM_FLAG is null
or RDB$SYSTEM_FLAG = 0 order by RDB$STATISTICS
And it returned 76 "records" all the same table and index but with different values for RDB$STATISTICS
ranging from 0.0001628664467716590 to 1.000000000000000
Over my head. How can there be 76 different values?
I just ran this
select 'MEMPAY1' AS TABLE_NAME, 'M1ID' AS INDEX_NAME, cast(RDB$STATISTICS as varchar(32)) as RDB$STATISTICS from rdb$indices where RDB$SYSTEM_FLAG is null
or RDB$SYSTEM_FLAG = 0 order by RDB$STATISTICS
And it returned 76 "records" all the same table and index but with different values for RDB$STATISTICS
ranging from 0.0001628664467716590 to 1.000000000000000
Over my head. How can there be 76 different values?
You got what you asked for.
Tthere are 76 tables and 76 indices, all of which have been returned with the
same name for the table and the index, respectively, due to your forcing a constant on
each. I have no idea why you think you have to do things like this.
HB