Home » Other » General » Indexing Timestamp
Indexing Timestamp [message #394087] Wed, 25 March 2009 12:21 Go to next message
startanew
Messages: 6
Registered: October 2008
Junior Member
Hi guys/gals
would like to know is it feasible to index a table column that store timestamp (e.g 12 mac 2009 18:54:09)

thank in advance

cheers
Re: Indexing Timestamp [message #394090 is a reply to message #394087] Wed, 25 March 2009 12:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Timestamp is just an extension for DATE datatype.
A better option is to index according to the format that will be used to query.
Re: Indexing Timestamp [message #394093 is a reply to message #394087] Wed, 25 March 2009 12:40 Go to previous messageGo to next message
startanew
Messages: 6
Registered: October 2008
Junior Member
hi thxs for the reply
sorry, what i mean is the date column..
so it is ok to index a datetime column..just to confirm
Re: Indexing Timestamp [message #394095 is a reply to message #394093] Wed, 25 March 2009 12:42 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Same response and
Yes you can.
Previous Topic: Telecom domain tips [Merged]
Next Topic: Maximo4.1.1 Aplication Error
Goto Forum:
  


Current Time: Fri Dec 02 12:32:24 CST 2016

Total time taken to generate the page: 0.10764 seconds