Database Software

Hello Everyone,

I am retrieving data from multidimensional cube using sql query, but my query takes lots of time for getting executed. Can anyone tell me why it is so?
The query is given below.

create type time_type_row as object (
month varchar2(55),
quarter varchar2(55),
year varchar2(55),
sales number(16),
day date,
product_name varchar2(44));
/

create type time_type_table as table of time_type_row;

SELECT sales, product_name,day
FROM TABLE(OLAP_TABLE(
'IND.IND_WS DURATION session',
'time_type_table',
'limit time KEEP time_levelrel ''DAY''',
'MEASURE sales FROM IND_FACT_SALES'))
where product_name='Energy Drinks' and day='12-dec-06';

I have seven dimensions and 51788 rows in the fact table used for the multidimensional build. Product and time are two of the dimensions used for filtering. Sales is the measure.

Does anyone experience same issue while retrieving the data from cube ?

Thanks.
Sanjeev

Message was edited by:
SanjeevK