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

Hi

You say that you are using 8i. If you have the Enterprise Edition you could try reading up on Materialized Views. They might be an alternative solution, though you should still follow the advice of Sybrand below first. 5 rows from 1/2 million sounds like it is selective enough that an indexed query would return the resultset in no time.

just another thought

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:972458427.17601.4.pluto.d4ee154e_at_news.demon.nl...


> 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/

>

>