Hi Gounden,
I woulds say, test it ! Nobody gets hurt when you built a view..
Alternative is putting a date field in your day dimension (don't you have
one there?).
rgds, Niek




"Gounden Sadasiwan "
<oracledba-ezmlmshield-x15082342.[Email address protected]
27-07-2006 07:36

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Function based index







Hi All

I am trying to convert a field which is number into date using a view.
What impact will it have on the performance when extracting information
using this view.
The table has about 1.3 billion records and is partitioned.

Example

Day no is 9000

When I convert this to date it will be 22/08/2004. then I would like
to select all the records for some particular date range using this
view.


Thanks

SADA



This e-mail and any attachments may contain confidential information that
is intended solely for the use of the intended recipient and may be
subject to copyright. If you receive this e-mail in error, please notify
the sender immediately and delete the e-mail and its attachments from your
system. You must not disclose, copy or use any part of this e-mail if you
are not the intended recipient. Any opinion expressed in this e-mail and
any attachments is not an opinion of RailCorp unless stated or apparent
from its content. RailCorp is not responsible for any unauthorised
alterations to this e-mail or any attachments. RailCorp will not incur any
liability resulting directly or indirectly as a result of the recipient
accessing any of the attached files that may contain a virus.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html



Oracle LazyDBA home page