Should a long field be separated into its own table?
From: Henry K. Yu <hyu_at_eng.umd.edu>
Date: 10 Aug 1994 13:58:25 GMT
Message-ID: <32ame1$np2_at_mojo.eng.umd.edu>
Date: 10 Aug 1994 13:58:25 GMT
Message-ID: <32ame1$np2_at_mojo.eng.umd.edu>
I was recently informed that a long field should be separated into its own table with key. For example, Table1 should be truned into Table2a and Table2b below. Does this really help in query performance?
Table1: key, f1, f2, f3, f4, longfield Table2a: key, f1, f2, f3, f4 Table2b: key, longfield
Regards, Henry Yu hyu_at_glue.umd.edu Received on Wed Aug 10 1994 - 15:58:25 CEST