kouchpotato
Programmer
Hi all,
we have a bespoke olap 9i database running at about 180g. This is suffering from performance degradation over the past few months.
Looking at the developers code there are a number of select * queries which are used, although these are indexed in the the where clause. We also analyse these tables weekly.
The tables accessed range between 3-14 million rows.
What is the overhead of the select * queries? is this filling the buffer cache with needless data and how bigger impact could this have on the overall performance of the database ?
Thanks in Advance
KP
we have a bespoke olap 9i database running at about 180g. This is suffering from performance degradation over the past few months.
Looking at the developers code there are a number of select * queries which are used, although these are indexed in the the where clause. We also analyse these tables weekly.
The tables accessed range between 3-14 million rows.
What is the overhead of the select * queries? is this filling the buffer cache with needless data and how bigger impact could this have on the overall performance of the database ?
Thanks in Advance
KP