select distinct values of a column against partitioned table

[kgandu]

Is there anyway that we can get the distinct values of the column on which there exist a partition.

eg : for my fact table the date is partitioned for each date. if i select the distinct values of dates
it is taking so much time to get the values.

infact these distinct values are being used for report development. every time they open report the dates available in the fact table should display so that users can
select particular date.

help us getting these distinct values fastly

[magicwand]

How do you define "distinct" in context with date (By year ? By month ? By week ? By day ? By hour ? By minute ?)

If partition pruning and/or partition key indexes will work depends on a couple of things.

But you sure didn't expect a complete answer without at least even mentioning the database release, let alone providing information about the type of partitioning, whether there are sub partitions, the partion keys and your query ...