Clustering Problem

With Oracle 7.0.13 and Solaris, I tried clustering one table on a single field. 85% of the records have one value for this field and 15% have the other value. TThe application only uses the 15% almost all the time so I expected the clustering to drastically reduce the elapsed time for their procesing, which is all scan type not inquiry on a single record. It worked but I find that when I use viewsfor some other reports, Oracle goes into a CPU loop for hours. Anyone else see this problem? There is no physical I/O going on in the period. I tried SQL trace which showed the plan it was following. It seemed reasonable. Received on Fri Oct 21 1994 - 13:43:19 CET