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

Thanks for the ideas, I'll do my reading on what you have suggested.

mr_oatmeal

Niall Litchfield wrote:
>
>
> 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/
> >
> >
>
>

--
Posted via CNET Help.com
http://www.help.com/