Re: view vs table and a developer w/o a dba

A table can have too many indexes.
The optimizer decides which index to use, if you have too many indexes it will make wrong decisions.
Try reading the Performance Tuning Manual.

Hth,

Sybrand Bakker, Oracle DBA

"mr_oatmeal" <mr_oatmeal_at_hotmail.com> wrote in message news:svc3cko6bo949e_at_corp.supernews.com...
> I look at those indexes....
>
> Can a table have too many indexes? Or can a table have different indexes
> for different queries?
>
> Thanks,
>
>
> 5defcon5 wrote:
> >
> >
> > A view is just SQL like anything else you write. It just hides
> > complexity from the user. So it will still have to execute. I would
> > work on those indexes . . . or batch the script that spits out the HTML.
> >
> > In article <svbhoth9g5gb03_at_corp.supernews.com>,
> > mr_oatmeal <mr_oatmeal_at_hotmail.com> wrote:
> > > Hello Reader,
> > >
> > > I am yet another rouge developer, let loose on developing and
 maintaining
> > > the database without a dba.
> > >
> > > Ok I was wondering if someone could give me some information to help
 me
> > > out...
> > >
> > > I have a web page that has five embedded sql statements. Each one
 hits
> > > the same table, the table has about 500,000 rows in it. (The table
 is
> > > already indexed.) Right now, the page takes too long to load and it
 is
> > > due to these queries. The query only selects five rows for each of
 the
> > > five categories. So, i was wondering if it would speed things up if I
> > > created a view to hold these 5 rows and just selecte from the view.
 Do
> > > you think it would be faster? Oh and how about maintaining the view
 if I
> > > go that route, is that a pain to update it everytime the table
 changes?
> > >
> > > Oh it helps, we are using Oracle 8i
> > >
> > > Thanks,
> > > mr_oatmeal
> > >
> > > --
> > > Posted via CNET Help.com
> > > http://www.help.com/
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Wed Oct 25 2000 - 01:40:35 CDT