OraFAQ Forum: General » Indexing Timestamp

Home » Other » General » Indexing Timestamp

Wed, 25 March 2009 12:21

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

Wed, 25 March 2009 12:33

Mahesh Rajendran
Messages: 10708
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.

Wed, 25 March 2009 12:40

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

Wed, 25 March 2009 12:42

Mahesh Rajendran
Messages: 10708
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: Tue Nov 26 04:38:45 CST 2024