Re: Evaluating the performance of ORACLE 10 DBMS - Any ideas on a research question?

Read240_at_hotmail.com wrote:
> Hello,
>
> I have been asked to evaluate a performance aspect of ORACLE 10 DBMS,
> e.g. clustering, indexing, normalization, query complexity.
>
> I have been asked to pick a research question the following example has
> been given "does indexing improve query performance?".
>
> Once I have picked a question I shall design a data model and query set
> to generate data and run the experiment.
>
> Does anyone have any ideas on significant research questions I will be
> marked on the reasons why i believe the question is significant.
>
> Thank You

Head over to tpc.org and build upon the research of others: http://tpc.org/tpch/results/tpch_result_detail.asp?id=105070801

oltp or ad-hoc (tpc-c vs. tpc-h)?
clustered or non-clustered (RAC)?
partitioned or not?

They provide source scripts, so you should be able to use their examples.

hth.

-bdbafh Received on Thu Jan 18 2007 - 13:33:25 CST