Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Performance Question
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
![]() |
![]() |