RE: Performance decreasing

Are you sure your index is useful? If your program fills your table(s) with lots of duplicate data, the usefulness of the index may decline. For example 100,000 rows with an index that only contains 2 values (ex: a table of people with an index on a male/female flag) probably won't perform all that well. The same table with an index of a few hundred values (ex: the area code of each person's phone number) will perform much better. Without knowing the nature of the data I can't say for sure; but the above indexing rule is something to watch for. .///. (0 o) -------------0000--(_)--0000--------------- sstuber@intrlnk.com oooO Oooo -------------( )-------( )--------------- \\ ( ) / \\_) (_/