Re: [GENERAL] Partial index question

2004-04-29 Thread John Sidney-Woollett
Anton Nikiforov said: > Dear All, > I have a question about using partial indexes. > Lets say i have a table containing data types (table_datatype) and the > table containing data entrys (table_data). > While inserting into data entrys i have to number the entrys according > to it's type, so i alwa

Re: [GENERAL] Partial index question

2004-04-29 Thread Anton Nikiforov
Paul Thomas пишет: 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 20 random records of two different types of data into it. Did you analyze the table afterwards? Hello and thanks for the