Home > database >  Postgre query speed
Postgre query speed

Time:11-02

Consult everybody:
I made a collection, data storage, database, a second collection, with date time field,
In order to speed up the query speed, whether I can put the date time field is defined as a clustered index? Because the query is mainly the where time is greater than the less than, is likely to have the same record time,
The same date, when the minutes (a second one data, possible time, then may modify system time, so it's possible date/time), so you can't build a primary key,
This is not set up the primary key, influential to query speed? In order to speed up the query, you have any Suggestions?
  • Related