On Fri, Dec 02, 2005 at 06:28:09PM -0500, Francisco Reyes wrote: > I am in the process of designing a new system. > There will be a long list of words such as > > -word table > word_id integer > word varchar > special boolean > > Some "special" words are used to determine if some work is to be done and > will be what we care the most for one type of operation.
Tough call. The key here is the amount of time required to do a join. It also depends on if you need all the special words or not. Your best bet is to try and benchmark both ways. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
