Performance Question

From: Thomas Keller <Thomas.Keller_at_debis.com>
Date: Thu, 29 Apr 1999 11:27:58 +0100
Message-ID: <3728342E.569D26A9@debis.com>

Hi,

I've got a table X with one primary-key-column X1K, a few attribute-columns X2, X3, X4 that are used a lot of times and another few attribute-columns (e.g. varchar2(2000)) X5, X6, X7, X8, X9 that are not used very often.

Now the question: what is better an why: 1) split the Table X in two tables X and Y, one with the pkey X1K and the often used columns X2, X3, X4 and the other with the pkey X1K and the other columns X5, X6, X7, X8, X9
2) create an index over X1K, X2, X3, X4 in just the original-table?

Thank you!

Thomas Keller Received on Thu Apr 29 1999 - 05:27:58 CDT