Hi,

If your tab is partitioned on this date number, it could be easyer if
you build a to_date like function. With your view, for every row the
date will be calculated before the select can pick the desired rows.

Bas

-----Oorspronkelijk bericht-----
Van: Gounden Sadasiwan
[mailto:oracledba-ezmlmshield-x15082342.[Email address protected]
Verzonden: donderdag 27 juli 2006 7:36
Aan: LazyDBA Discussion
Onderwerp: 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