Performance of column order

Started by Egon Sommeralmost 24 years ago1 messagesgeneral
Jump to latest
#1Egon Sommer
Service@Sommer-Maschinenbau.de

Hallo!

Do anybody know if the order of the columns in a table has affect on the performance?

Should I use length-variable colums like TEXT, BLOB,... alfter length-static colums like INTEGER, BOOLEAN, ...?

Is there a advantage to create a separate table for BLOBS and TEXT joining the main table about a primary key?

Thanks for help
J�rg Sommer

--------------------------------------------------------------------------
Sommer Maschinenbau
Pagenstecherstr. 146
49090 Osnabr�ck

0049 (0)541 125085
0049 (0)541 129557

Service@Sommer-Maschinenbau.de
--------------------------------------------------------------------------