Home » SQL & PL/SQL » SQL & PL/SQL » Index on Date Field (Oracle 10g R-2)
Index on Date Field [message #277405] Mon, 29 October 2007 23:52 Go to next message
nirajksharmacpr
Messages: 19
Registered: October 2007
Location: Mumbai
Junior Member

Hi All
I want To Create Index on Date Data Type. is this a Bad Idea. Please Suggest Me.

Thanks and Regards.

Niraj
Re: Index on Date Field [message #277408 is a reply to message #277405] Tue, 30 October 2007 00:03 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> I want To Create Index on Date Data Type.
Why does data type matter?
>is this a Bad Idea.
The world is NOT black & white or good & bad.
>Please Suggest Me.
Benchmark & decide accordingly.
Previous Topic: Need to insert values into table
Next Topic: function based index using new_time function
Goto Forum:
  


Current Time: Wed Dec 07 12:31:21 CST 2016

Total time taken to generate the page: 0.26739 seconds