Subject | firebird 2,0 and index optimization |
---|---|
Author | ibrahim bulut |
Post date | 2007-06-13T16:34:26Z |
Does firebird 2 use indexes more functionally and fast with aggregate
functions.
I use views with aggregate functions.
If i have a view that uses a group by function by id and i want to read a
record from this view,
does optimizer scan all records for calculating the data and build all the
view or optimizer scan only records that i want from it.
[Non-text portions of this message have been removed]
functions.
I use views with aggregate functions.
If i have a view that uses a group by function by id and i want to read a
record from this view,
does optimizer scan all records for calculating the data and build all the
view or optimizer scan only records that i want from it.
[Non-text portions of this message have been removed]