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

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

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

From: ramprakash <ramprakash.a_at_gmail.com>
Date: 20 Mar 2006 07:04:05 -0800
Message-ID: <1142867045.019674.160030@j33g2000cwa.googlegroups.com> 





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.



for example take the emp table


 one of the query where condition is NAME in another hiredate , mgr ...



Regards


Ram
Received on Mon Mar 20 2006 - 09:04:05 CST












Original text of this message













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