Re: efficient placement of fields

2003-08-14 Thread Roger Baklund
* [EMAIL PROTECTED] > Hi is there any noticable efficiency is ordering the position of the field > types?. Like say i place the join keys in a table at the end, and varchars > and text at the top of the table does it really matter? Have you tried? I would guess it does not matter. But for some rea

efficient placement of fields

2003-08-14 Thread daniel
Hi is there any noticable efficiency is ordering the position of the field types?. Like say i place the join keys in a table at the end, and varchars and text at the top of the table does it really matter? Also when i do a query like select * from table where id IN (1), where 1 is usually a primar