티스토리 뷰

공부

[MySQL] date column index

승가비 2023. 12. 4. 07:04
728x90

https://stackoverflow.com/questions/20938753/does-it-improve-performance-to-index-a-date-column

 

Does it improve performance to index a date column?

I have a table with millions of rows where one of the columns is a TIMESTAMP and against which I frequently select for date ranges. Would it improve performance any to index that column, or would ...

stackoverflow.com

 

728x90
저작자표시 비영리 (새창열림)

'공부' 카테고리의 다른 글

[kotlin] data class Comparable  (0) 2023.12.04
[Spring] 순환 참조(Circular References) -> @Lazy  (0) 2023.12.04
[IntelliJ] IDEA offers an option to Optimize imports on the fly in Settings | Editor | General | Auto Import and Optimize imports option in the Commit Project dialog.  (0) 2023.12.04
[MySQL] WHERE binary c = 'abc'  (1) 2023.12.04
[MySQL] ALTER TABLE `table` ADD `c` VARCHAR(200) NOT NULL FIRST; ALTER TABLE `table` ADD `c` VARCHAR(200) NOT NULL AFTER  (0) 2023.12.04
댓글