In a DW, you have 2 kinds of indexes : the bitmap
indexes on the fact table and the btree/bitmap indexes
on the dimension tables.
If it's for a known query, then you can trace it and
check the access plan.
- Lisa_Koivu_at_gelco.com a écrit:
> Hello -
>
> Does anyone have a quick and dirty way to tell if an
> index is being used? This
> is a DW environment.
>
> Thanks
> Lisa
>
>
>
>
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Tue May 09 2000 - 10:44:30 CDT