Subject Re: [ib-support] view on a table to speed up queries
Author Jan Agermose
On Mon, 2002-04-22 at 13:16, Svein Erling Tysvær wrote:

>4. make a collection of views on the log table...

forget option 4 - views are basically queries on underlying table(s) and
cannot be used for increasing speed.

I'm not certain if logging to a table is a good idea at all,

we need to do a lot of online event report generation and statistics
querying. I don't think file logging is suitable for this?

but others
will be able to tell you more about that and about your other three
options. But if you do, I do not understand why you don't have any
additional indexes besides the primary key.

This was to avoid performance problems because we do a lot of inserts.

Have you tried having an index
on (logtype, PrimaryKey)? Indexes should be close to unique, so having an
index on logtype alone could lead to performance degradation (though I'm
not certain if this matters for inserts or only affects deletes), so adding
the PK to the index can be quite useful.

does multicolumn indexes make sense if you use them in a non multicolumn
query? Do I need to make use of a explicit PLAN statement? I'm not sure
I understand how and when to use PLAN. Do you know of a good description
on this feature?

Jan Agermose

[Non-text portions of this message have been removed]