Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Database Index 추가 #275

Closed
softpeanut opened this issue Jan 4, 2023 · 0 comments · Fixed by #277
Closed

Database Index 추가 #275

softpeanut opened this issue Jan 4, 2023 · 0 comments · Fixed by #277
Assignees
@softpeanut
Labels
performance 성능을 개선 할 경우

Comments

@softpeanut
Copy link
Member

Describe

  • 카디널리티가 높은 컬럼 (중복 x) - 기수성 높음
  • 삽입/변경이 적고 조회가 많은 컬럼
  • 다중 컬럼으로 구성할 때에는 순서에 유의

Additional

  • 해당 경우에는 인덱스가 적용되지 않음

image

  • 다중 컬럼으로 이루어진 인덱스의 참고사항

image
@softpeanut softpeanut added the performance 성능을 개선 할 경우 label Jan 4, 2023
@softpeanut softpeanut self-assigned this Jan 4, 2023
softpeanut added a commit that referenced this issue Jan 4, 2023
@softpeanut
pref: (#275) Index 설정
a69a765
@softpeanut softpeanut mentioned this issue Jan 4, 2023
Merged
6 tasks
softpeanut added a commit that referenced this issue Jan 4, 2023
@softpeanut
perf: (#275) ScheduleJpaEntity index DESC -> ASC
ff89a8b
softpeanut added a commit that referenced this issue Jan 4, 2023
@softpeanut
merge: (#275) Index 설정 (#276)
379f43b
softpeanut added a commit that referenced this issue Jan 4, 2023
@softpeanut
chore: (#275) columnList 소문자 -> 대문자
8776e39
softpeanut added a commit that referenced this issue Jan 4, 2023
@softpeanut
chore: (#275) UserJpaEntity index 삭제
e4336e2 
unique column에는 기본적으로 unique index 설정
@softpeanut softpeanut mentioned this issue Jan 4, 2023
Merged
4 tasks
@github-project-automation github-project-automation bot moved this from Todo to Done in SimTong-Backend Backlog Jan 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@softpeanut softpeanut

Labels
performance 성능을 개선 할 경우
Projects
SimTong-Backend Backlog
Status: Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

release(DB 인덱스 추가): 1.2.2 Team-ComIT/SimTong-Backend
1 participant
@softpeanut