The select statement is: select objid from trafficassignmentpersistent where subclassidentifier = 17; Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -----Original Message----- Sent: Friday, June 29, 2001 10:53 AM To: Multiple recipients of list ORACLE-L Subject: Re: Why are my indexes being ignored? What is the sql statement that you are executing against this table? Carle, William T (Bill), NLCIO wrote: >Hi, > > I created an index on a table. The table has about 83,000 rows. The >index is a simple index on one field, 35 different values of the index. I >analyzed the table and I analyzed the index, trying it both with a histogram >and without a histogram. No matter how I do it, it does a full table scan. >Any ideas why? I know I can use a hint, but it seems to me that it ought to >use the index. > > >Bill Carle >AT&T >Database Administrator >816-995-3922 >[EMAIL PROTECTED] > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are my indexes being ignored?
Carle, William T (Bill), NLCIO Fri, 29 Jun 2001 09:01:04 -0700
- Why are my indexes being ignored? Carle, William T (Bill), NLCIO
- Re: Why are my indexes being ignored? Joe Raube
- RE: Why are my indexes being ignored? Carle, William T (Bill), NLCIO
- Re: Why are my indexes being ignored? Thater, William
- RE: Why are my indexes being ignored? Mohan, Ross
- RE: Why are my indexes being ignored? Harvinder Singh
- RE: Why are my indexes being ignored? Nicoll, Iain (Calanais)
- RE: Why are my indexes being ignored? Carle, William T (Bill), NLCIO
- RE: Why are my indexes being ignored? Raymond Lee Meng Hong