On Jan 28, 7:40 am, "bobdu...@gmail.com" <bobdu...@gmail.com> wrote:
> Hi,Well, I'm guessing that your 20 column index is just not the best one
> I have a basic event table in my 10g database, primary integer key,
> select min(eventdate) from events;
> It can occasionally take a VERY long time. There is a standard btree
for your min. What happens if you make a btree index on just that
eventdate column? It's been my experience that any table with more
than a few columns in an index isn't properly normalized.
There might be bug/patch issues, too. timestamp is relatively new,
How are you loading this table? What is the exact definition of the
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.