Tunning Timestamp field [message #65621] |
Wed, 10 November 2004 23:18 |
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.
|
|
|
|