Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PO Lite index question
Hi Schoeneck,
Go out and invest in a couple of books on Oracle performance tuning. Start looking at the following:
If your target systems have more than one drive you want to distribute
Oracle and your database across all available spindles. Oracle will
take
advantage of up to seven spindles.
Did you analyze the tables and indexes? If not, run analyze and then
try your
query again.
Does your where clause include functions on the index column? If so the
index
won't be used. The solution is to revise the logic of the where clause
so that
functions are only used against the variable or constant the index value
is
being compared to.
You are using the CD-ROM only as a distribution device aren't you? I
mean Oracle
may run off of a CD-ROM, but I guarantee you will get lousy performance
unless you
move everything onto hard drives.
If you tune any version of Oracle you can get excellent performance.
You also
avoid pitfalls such as using clauses and conditions that result in
Oracle doing
a full table scan instead of using the indexes.
Regards
Jerry
Schoeneck Howell wrote:
>
> I'm looking at PO Lite (ver 3.0.5.x) as a replacement DB
> engine for an in-house strategic support system we
> distribute on CD. In trying to evaluate the differences, I
> set up a new database, and moved a few of our existing data
> files into tables in the DB, with indexes created for
> location and date code columns on each table. No problem
> so far. No errors, and the structures were visible in the
> Navigator (although I never did get to browse the data from
> the larger table via the Navigator, after several minutes of
> watching the drive light flash with no response coming to
> the screen, I aborted the operation).
>
> Running a select from the larger table in the test set
> (20,000 rows) and specifying a location code, took 4 minutes
> to return the 77 corresponding rows. The index for this
> table consisted of the location code and date code, in that
> order. I would have to guess that the index was not used by
> PO Lite in running that query. Did I make a mistake here?
> I hope that Lite is capable of better performance.
>
> +=+=+=+=+=+=+=+=+=+=+=+=
> skhowell @ earthlink . net
> +=+=+=+=+=+=+=+=+=+=+=+=
> showell_at_bop.gov
> +=+=+=+=+=+=+=+=+=+=+=+=
-- Jerry Gitomer Since I know how to spell DBA I became one. jgitomer_at_p3.netReceived on Sat Mar 14 1998 - 00:00:00 CST