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 -> Big table help needed

Big table help needed

From: Larry Schenavar <schenavar_at_northstate.net>
Date: Fri, 1 May 1998 15:35:22 -0400
Message-ID: <6id84d$bj3$2@news1.infoave.net>


I have a 4 column table with 8 million rows. The key is 3 of the columns(one of them is a date). The table is very slow to query. Will creating an index on those three columns help? any other thoughts.

--



Larry Schenavar
Infrastructure Specialist /DB
Electronic Data Systems, Inc

Email: schenavar_at_northstate.net


Received on Fri May 01 1998 - 14:35:22 CDT

Original text of this message

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