The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.server
From: Robert Klemme <shortcut...@googlemail.com>
Date: Wed, 30 Jan 2008 02:02:11 -0800 (PST)
Local: Wed, Jan 30 2008 5:02 am
Subject: Re: long running select min(timestamp) query
On Jan 29, 10:36 pm, "bobdu...@gmail.com" <bobdu...@gmail.com> wrote:
> I definitely have done some large scale deletes. When i say I doubt it makes a difference for the min/max types of queries but do > occasionally, there have been times when the query has been fast, but > it hasn't been fast in a long time... likely since the last large > scale delete operation actually. you update statistics on a regular basis, or at least after such mass deletes? There *may* be an impact if concurrently running queries are less efficient because of stale statistics and your IO becomes slower just because of increased concurrent IO load. > I just tried to get more stats via the following call, and then Maybe you can even update the whole schema's statistics if you haven't > checked again for chained rows (not sure if it would've affected, but > tried anyways): > SQL> exec done in a time or on a regular basis. Do you have system statistics set? Kind regards You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||