Re: here is another oracle 10g's bug?

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 20 Jun 2007 06:23:12 -0700
Message-ID: <1182345789.107766@bubbleator.drizzle.com>

Havel Zhang wrote:

> And I did try drop and recreate index on store_product. Before
> recreate index, result is 28827. Very strange:) after I recreated this
> index, result is 64172. also wrong but close to right figure:), after
> i drop that index, i get correct result finally.

Post the DDL for the table and the index.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Jun 20 2007 - 08:23:12 CDT