Re: Partial index question

On 29/04/2004 09:53 Anton Nikiforov wrote:
> looks like after a few tests that i've done i'm confused more than
> before.
> I did create a table and inserted 200000 random records of two different
> types of data into it.

Did you analyze the table afterwards?

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+