[PERFORM] Bad Index Choices with user defined data type

2005-01-03 Thread Adam Palmblad
I've got a table using a data type that I have created as the type for its primary key. I (hope) I have the type set up properly - it seems okay, and does not have any problem creating a b-tree index for the type. The problem I am having is that the index seems to never be chosen for use. I

Re: [PERFORM] Bad Index Choices with user defined data type

2005-01-03 Thread Michael Fuhr
On Mon, Jan 03, 2005 at 01:44:27PM -0800, Adam Palmblad wrote: I've got a table using a data type that I have created as the type for its primary key. I (hope) I have the type set up properly - it seems okay, and does not have any problem creating a b-tree index for the type. The problem I