Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA28383 for postgres-dist; Thu, 24 Mar 1994 17:21:57 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199403250121.RAA28383@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from garam.kreonet.re.kr ([134.75.30.11]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA28374 for <postgres@postgres.berkeley.edu>; Thu, 24 Mar 1994 17:21:51 -0800
Received: from hyowon.pusan.ac.kr by garam.kreonet.re.kr (4.1/GARAM-MX-1.0)
	id AA20972; Fri, 25 Mar 94 10:23:32 KST
Received: by hyowon.pusan.ac.kr (AIX 3.2/UCB 5.64/hyowon-0.1)
          id AA43749; Fri, 25 Mar 1994 10:15:31 -1500
Date: Fri, 25 Mar 1994 10:15:31 -1500
From: kskim@hyowon.pusan.ac.kr (kim kyongsok)
Message-Id: <9403260115.AA43749@hyowon.pusan.ac.kr>
To: postgres@postgres.Berkeley.EDU
Subject: index and # of tuples
Cc: clcho@asadal.pusan.ac.kr, hwyun@hyowon.pusan.ac.kr,
        jhlee@asadal.pusan.ac.kr, kskim@hyowon.pusan.ac.kr,
        yhkim@asadal.pusan.ac.kr, yjjeong@asadal.pusan.ac.kr
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Thu, 24 Mar 94 17:21:57 -0800
Resent-XMts: smtp


we defined a user-def data type, defined an index on a field of that type,
and tested to see if the index is used.

it seems that the index will be actually used (e.g., in retrieval)
when the number of tuples exceeds some thereshold value 
(probably for query opt.?).

is it the case?

thanks in advance.

k kim