Hi,I am going to test this out but would be good to know anyways. A largetable is joined to a tiny table (8 rows) on a text field. Should I bejoining on an int field eg: recid intead of name? Is the performanceaffected in either case?Thanks .