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
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.

Re: Index on Date Field [message #277408 is a reply to message #277405] Tue, 30 October 2007 00:03 Go to previous message
Messages: 25525
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: Sat Jul 22 04:22:15 CDT 2017

Total time taken to generate the page: 0.10291 seconds