Re: Limit on number of columns in an index
From: Riku Räsänen <riku.rasanen_at_kantamestarit.fi>
Date: Wed, 19 Mar 2008 21:10:44 +0200
Message-ID: <op.t79176lurkn1vh@smtp.saunalahti.fi>
Date: Wed, 19 Mar 2008 21:10:44 +0200
Message-ID: <op.t79176lurkn1vh@smtp.saunalahti.fi>
Woops... should have read more carefully. Sorry, my bad.
But my thoughts for your question: If 30-column index is necessary, then it is. It does sounds a bit extreme, though, but if it does the job and there are no better solutions (like IOT), then I'd go for it.
-- Riku Räsänen Kantamestarit OY riku.rasanen_at_kantamestarit.fi +358 (0)50 548 0589 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 19 2008 - 14:10:44 CDT