Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: indexing issue, need alternate solution to improve the query performance

Re: indexing issue, need alternate solution to improve the query performance

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 20 Mar 2006 16:38:21 +0100
Message-ID: <dvmi9d$b33$1@nntp.fujitsu-siemens.com> 





ramprakash schrieb:


> Hi,

> 

> Its oracle 9i release 2,  running on windows box.

> if i need to create index,

> i have to index all the columns because,  where condition in the select

> query contains almost all the columns.

Would it help if you partition the table, thereby making the indexes smaller?



Lots of Greetings!


Volker
Received on Mon Mar 20 2006 - 09:38:21 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US