Re: Has any ne used create dimension in oracle 8?

It looks as if what you want is a materialized view of the form:

    create or replace materialized view

        .... extra lines in here
    as

        select ps_id, ls_id, sum(salesprice)
        from ms1_tab
        group by ps_id, ls_id

If a summary table created like this reduces your number of rows by a factor of about 10 then it could be beneficial to create the MV.

Most queries of the form you have supplied would then go to the MV.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Parvinder Singh wrote in message <38A25B54.7A099F7E_at_questone.com>...
>
>
>dave mausner wrote:
>
>> parora_at_questone.com (Parvinder Singh) wrote in
>> <389AA9E7.7F7058E0_at_questone.com>:
>>
>> >Hi all oracle 8 pros
>> >
>> > Has any one used the dimension feature of oracle - 8 ?? if yes can u
>> >please tell me how can i view data stored in a dimension
>>
>> the usual way: select X from Table where ...
>>
>> a dimension is a way to supply information to the query-rewriting process
>> so that dynamic aggregated views can be performed. you do not invoke the
>> dimension directly to look at the data yourself.
>
>Thanks Dave
>If i have a query something like this
>
>select pd_id, ls_id sum(salesprice)
>from ms1_tab
>where pd_id >0 and pd_id<244
>and ls_id >0 and ls_id <66
>can i create materialized view with respect to query like this ?? (coz the
0,
>244 and 66 is the variable part and that will be the dynamic...) any idea
??
>
>one way which i have thought is create a temporary table with respect to
the
>dynamic values and then may be equate that field with the table where the
>values are stored ...what do u say ?
>
>
>>
>> --
>> dave mausner
>
Received on Thu Feb 10 2000 - 01:47:04 CST