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: help: query tuning

Re: help: query tuning

From: Dries Germonrpez <ips_at_se.bel.alcatel.be>
Date: Mon, 12 Jul 1999 16:00:46 +0200
Message-ID: <3789F50E.52E8E624@se.bel.alcatel.be> 





Off course oracle will do a full table scan if you don't have any
indexes! What else should do?


How come you can't create any indexes?



ewong74_at_netscape.net wrote:


> table_a has 300k rows, table_b has 100k rows.


> Both tables have no indexes and i cannot create any indexes on them.


> When I do an explain plan, it looks like oracle are doing full table


> scan for both tables.


Received on Mon Jul 12 1999 - 09:00:46 CDT












Original text of this message













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