Home » RDBMS Server » Performance Tuning » Tunning Timestamp field
Tunning Timestamp field [message #65621] Wed, 10 November 2004 23:18 Go to next message
Rosa Quevedo
Messages: 5
Registered: November 2004
Junior Member
 

Hello,

My problem is that I'm using a large amount of data, 60 million records, I'm accessing the data through a timestamp column, and I get a full access to the table so the response time is very high, and I need to reduce it.

I suggest that we separate the timestamp fiel into three different columns: date(dd/mm/yyyy), hour (hh24:mi:ss) and miliseconds and include each column in an index. I would appreciate any suggestions.

Thanks.

 

 
Re: Tunning Timestamp field [message #65622 is a reply to message #65621] Thu, 11 November 2004 02:08 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please don't cross-post

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: Slow performance of DBPLease help!
Next Topic: ORA-27100: shared memory realm already exists
Goto Forum:
  


Current Time: Wed Sep 30 09:45:22 CDT 2020