profile
๐Ÿš€ ๊ธฐ๋ก๋ณด๋‹จ ๊ธธ๋ก์„ โญ
ํƒœ๊ทธ ๋ชฉ๋ก
์ „์ฒด๋ณด๊ธฐ (460)ํ• ์ผ(141)Java(34)Spring(22)python(21)gil.log(15)mysql(13)๊ฐœ๋…(10)์ž๋ฐ” ์„ฑ๋Šฅ ํŠœ๋‹ ์ด์•ผ๊ธฐ(9)์—๋Ÿฌ(8)linux(8)Springboot(8)JPA(8)eclipse(7)์ž๋ฃŒ๊ตฌ์กฐ(7)migration(6)jquery(6)Swagger(6)db(6)MacOS(6)์•Œ๊ณ ๋ฆฌ์ฆ˜(6)sql(6)vscode(6)php(5)Modern Java In Action(5)JavaScript(5)@RequestParam(4)lambda(4)List(4)ide(4)error(4)exception(4)cors(3)set(3)DDaJa(3)API(3)class(3)stream(3)stack(2)collections(2)RequestHeader(2)queue(2)Interceptor(2)RequestBody(2)mac(2)์ž๋ฃŒํ˜•(2)abstract class(2)di(2)Cheat Sheet(2)coding test(2)ํ•ด๊ฒฐ(2)Map(2)vue.js(2)macbook(2)@PathVariable(2)param(2)404(2)ํƒ์ƒ‰(2)regular expression(2)exception handling(2)String(2)http(2)dictionary(2)REST API(2)interface(2)Spring boot(2)๋””์ž์ธ ํŒจํ„ด(2)jsp(2)REST(2)ํŠœ๋‹(2)preflight(2)protocol(2)COLUMN(2)jQuery Migrate(2)Java 8(2)restful api(2)MVC(2)aws(2)Builder(2)maven(2)Hibernate(2)MyBatis(2)parameter(2)์ •๊ทœ ํ‘œํ˜„์‹(2)@ExceptionHandler(2)Index(2)git(2)transaction(2)Text Mining(2)LomBok(2)Design Pattern(2)case(2)EL(2)servlet(1)๊ณ„ํš(1)๊ธฐ์ˆ ๋ธ”๋กœ๊ทธ(1)terminal(1)functional programming(1)HashTable(1)์˜ˆ์™ธ์ฒ˜๋ฆฌ(1)StringBuilder(1)modjk(1)DispatcherServlet(1)data type(1)modelattribute(1)iteration(1)rpm(1)HashMap(1)์ƒํƒœ์ฝ”๋“œ(1)stomp(1)TreeMap(1)csrf(1)batch(1)HashSet(1)๋ณ€์ˆ˜๋ช…(1)PriorityQueue(1)CORS policy(1)๋งˆ์ด๊ทธ๋ ˆ์ด์…˜(1)๋ฒ„๋ธ” ์ •๋ ฌ(1)์„ ํƒ ์ •๋ ฌ(1)INSERT(1)Working set(1)๋น„๊ต์—ฐ์‚ฐ์ž(1)Mac Os(1)VO(1)optional(1)const(1)let(1)var(1)excel(1)tomcat(1)์ •๋ ฌ(1)์‹œ๊ฐ„๋ณต์žก๋„(1)ArrayList(1)annotation(1)anaconda(1)Table(1)hibernate.hbm2ddl.auto(1)sessionStorage(1)formData(1)์ž๋ฃŒ ๊ตฌ์กฐ(1)localstorage(1)resolver(1)file(1)์‹ ์ž…๊ฐœ๋ฐœ์ž(1)ํŒจํ„ด(1)Builder Pattern(1)AutoConfiguration(1)methods(1)bean(1)ํ•ด์ƒ๋„(1)header(1)yaml(1)์ œ์–ด๋ฌธ(1)์›์‹œํƒ€์ž…(1)์ฐธ์กฐํƒ€์ž…(1)aop(1)coding convention(1)junit(1)svn(1)environment(1)jar(1)DTO(1)PORT(1)require(1)Big O(1)StringBuffer(1)๊ฐ์ฒด ์ง€ํ–ฅ ํ”„๋กœ๊ทธ๋ž˜๋ฐ(1)options(1)RuntimeException(1)BigInteger(1)ObjectMapper(1)container(1)replace(1)๋‚™์„œ์žฅ(1)View(1)testcode(1)@Valid(1)dependency(1)include(1)wrapper(1)group by(1)durability(1)Isolation(1)controlleradvice(1)Junit 5(1)distinct(1)annotations(1)phantom read(1)dirty read(1)isolation level(1)ALTER TABLE(1)๋“€์–ผ ๋ชจ๋‹ˆํ„ฐ(1)commands(1)Camera(1)access token(1)first class(1)Primenumber(1)TreeSet(1)transient(1)ํƒ์š• ์•Œ๊ณ ๋ฆฌ์ฆ˜(1)๋ช…๋ นํ˜• ํ”„๋กœ๊ทธ๋ž˜๋ฐ(1)ํ™˜๊ฒฝ(1)์‚ฐ์ถœ๋ฌผ(1)pageContext(1)COALESCE(1)consistency(1)ANSI SQL(1)EXPLAIN PLAN(1)Data Dictionary(1)Math.class(1)LinkedHashSet(1)LinkedHashMap(1)PrimitiveType(1)ReferenceType(1)์„œ์‹(1)๊ด€์  ์ง€ํ–ฅ(1)์šฐ์„  ์ˆœ์œ„ ํ(1)Tibero(1)Command Object(1)HttpServletRequest(1)๋™์  ์ฟผ๋ฆฌ(1).find()(1)๋‚ด์žฅ ํ•จ์ˆ˜(1)DATE_FORMAT(1)NonClustered Index(1)Clustered Index(1)SQL Partition(1)์„ ํƒ๋ฌธ(1)webcam(1)TestCase(1)spring-boot-starter(1)DB Export(1)DB Import(1)ํ‘œ์ค€ Library(1)ddl auto(1)throwable(1)๊ต์ฐจ ์ถœ์ฒ˜ ๋ฆฌ์†Œ์Šค ๊ณต์œ (1)defaultdict(1)MyISAM(1)InnoDB(1)HandlerInterCeptor(1)์ผ๊ธ‰ ์‹œ๋ฏผ(1)moshi(1)MessageConverter(1)@lob(1)api server(1)enumerated(1)currentTimeMillis(1)@MappedSuperclass(1)๋ฌธ์žํ˜•(1)string class(1)CentOS 6.9(1)mirrorlist(1)ius(1)CentOS6.9(1)Logrotate(1)ํด๋ฆญ ์—ฐ๊ฒฐ(1)์ ์ธต์  ์ƒ์„ฑ์ž ํŒจํ„ด(1)JavaBeans Pattern(1)MVC ๋ชจ๋ธ(1)๋‹จ์ถ•ํ‚ค ์ •๋ฆฌ(1)Transfer Object Pattern(1)Service Locator(1)ํ”„๋กœํŒŒ์ผ๋ง ํˆด(1)Profiling Tool(1)์„ฑ๋Šฅ ์ธก์ •(1)Profilling Tool(1)์ž๋ฐ” ์„ฑ๋Šฅ ๊ฐœ์„  ์ด์•ผ๊ธฐ(1)์‘๋‹ต ์‹œ๊ฐ„ ํ”„๋กœํŒŒ์ผ๋ง(1)๋ฉ”๋ชจ๋ฆฌ ํ”„๋กœํŒŒ์ผ๋ง(1)Memory Profiling(1)ResponseTime Profiling(1)System Class(1)System Class Property Methods(1)VLOOKUP(1)nanoTime(1)emit(1)JMH(1)TransferObject(1)Implicit Objects(1)applicationScope(1)pageScope(1)initParam(1)sessionScope(1)requestScope(1)paramValues(1)MultiValueMap(1)@SessionAttributes(1)headerValues(1)Atomicity(1)Nonrepeatable Read(1)UncheckedException(1)CheckedException(1)์ด๊ธ‰ ์‹œ๋ฏผ(1)์ „์ฒด ๊ฒ€์ƒ‰(1)ModernJavaInAction(1)๋™์ž‘ ํŒŒ๋ผ๋ฏธํ„ฐํ™”(1)Behavior Parameterization(1)swagger2(1)-Dspring.profiles.active(1)Spring Fox(1)Java Builder(1)OAS_30(1)@ApiResponse(1)SWAGER_2(1)Kill(1)์ž๋ฐ” ORM ํ‘œ์ค€ JPA ํ”„๋กœ๊ทธ๋ž˜๋ฐ(1)web-app-filter-name-uniqueness(1)lsof(1)jjwt(1)์™ธ๋ถ€ ๋ชจ๋‹ˆํ„ฐ(1)M1 MacBook(1)alter table column(1)IDENTITY(1)@Temporal(1)์—ฐ๊ด€ ๊ด€๊ณ„ ์ฃผ์ธ(1)์–‘๋ฐฉํ–ฅ ๋งคํ•‘(1)๋‹ค๋Œ€์ผ ๊ด€๊ณ„(1)๊ณตํ†ต Entity(1)Column Field Mapping(1)์—ฐ๊ด€๊ด€๊ณ„ ํŽธ์˜ ๋ฉ”์†Œ๋“œ(1)RequestHeaderMapMethodArgumentResolver(1)HandlerMethodArgumentResolver(1)HandlerInterceptorAdapter(1)NoHandlerFoundException(1)Class.isAssignableFrom(1)MethodArgumentResolver(1)Handler Parameter(1)PathVariableMethodArgumentResolver(1)RequestParamMethodArgumentResolver(1)WebMvcConfigurer(1)AJP(1)Please use a personal access token instead(1)HandlerExceptionResolver(1)customize property(1)application.properties(1)@ConfigurationProperties(1)this.$ref(1)this.$parent(1)๋ฏธ๋ฆฌ์บ”๋ฒ„์Šค(1)Rfc3339DateJsonAdapter(1)์˜ˆ์™ธ ์ „ํ™˜(1)์˜ˆ์™ธ ํšŒํ”ผ(1)์˜ˆ์™ธ ๋ณต๊ตฌ(1)resolveException(1)OAS(1)regexp(1)1๋…„(1)algorithm(1)plan(1)Collection(1)access(1)slicing(1)ifnull(1)ps(1)instanceof(1)comparable(1)Rollback(1)formatting(1)ACID(1)comparator(1)@property(1)SIDEPROJECT(1)์ ‘๊ทผ ์ œํ•œ์ž(1)sequence(1)์†Œ์ˆ˜ ์ฐพ๊ธฐ(1)R(1)promise(1)velog(1)tcp(1)Markdown(1)๋งˆํฌ๋‹ค์šด(1)์ž๋ฐ”(1)์กฐํ•ฉ(1)cookie(1)math(1)array(1)github(1)JWT(1)web(1)๋ฉด์ ‘(1)Module(1)OOP(1)Python3(1)iBatis(1)pattern(1)async(1)๋น„๋™๊ธฐ(1)Constraint(1)entity(1)runtime(1)framework(1)library(1)์Šคํ„ฐ๋””(1)Side Project(1)ssh(1)programmers(1)DP(1)์†Œ์ˆ˜(1)url(1)Database(1)BFS(1)spring security(1)IntelliJ(1)ํ† ์ดํ”„๋กœ์ ํŠธ(1)๋‹จ์ถ•ํ‚ค(1)cmd(1)hint(1)pycharm(1)ํ”„๋กœํŒŒ์ผ๋ง(1)๊ฒ€์ฆ(1)Generic(1)DFS(1)์ •๋ ฌ ์•Œ๊ณ ๋ฆฌ์ฆ˜(1)validator(1)jdk(1)linked list(1)component(1)POST(1)domain(1)Props(1)ํ•จ์ˆ˜ํ˜• ํ”„๋กœ๊ทธ๋ž˜๋ฐ(1)IoC(1)status code(1)IO(1)profile(1)json(1)counter(1)select(1)SYSTEM(1)๋ฌธ๋ฒ•(1)tuple(1)function(1)package(1)command(1)๋ฐ˜๋ณต๋ฌธ(1)์ˆœ์—ด(1)reference(1)recursion(1)
post-thumbnail

[SQL] Clustered Index & Non-Clustered Index

์•ž์„œ Index์— ๋Œ€ํ•ด์„œ ์ •๋ฆฌ ํ–ˆ์—ˆ์ง€๋งŒ, Clustered Index์™€ Non-Clustered Index๋ฅผ ์ž์„ธํžˆ ๋‹ค๋ฃจ์ง€ ์•Š์•„ ์ด๋ฒˆ ์‹œ๊ฐ„์— ์ž์„ธํžˆ ๋‘ Index์˜ ์ฐจ์ด๋ฅผ ์ •๋ฆฌํ•ด๋ณด๋ ค ํ•œ๋‹ค.Index๋Š” DB์˜ ํ…Œ์ด๋ธ”์— ๋ฐ์ดํ„ฐ๊ฐ€ ๋งŽ์„ ๋•Œ, ๊ฒ€์ƒ‰ ์†๋„๋ฅผ ํ–ฅ์ƒ์‹œ์ผœ์ฃผ๊ธฐ์œ„ํ•ด ์‚ฌ์šฉ

2020๋…„ 11์›” 30์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€

[SQL] EXPLAIN PLAN

EXPLAIN PLAN์ด๋ž€ SQL๋ฌธ์˜ ์•ก์„ธ์Šค ๊ฒฝ๋กœ๋ฅผ ํ™•์ธํ•˜๊ณ  ํŠœ๋‹ํ•  ์ˆ˜ ์žˆ๋„๋ก SQL๋ฌธ์„ ๋ถ„์„, ํ•ด์„ํ•ด ์‹คํ–‰๊ณ„ํš์„ ์ˆ˜๋ฆฝํ•œ ํ›„ PLAN_TABLE์— ์ €์žฅํ•˜๋Š” ๋ช…๋ น์ด๋‹ค.SQL๋ฌธ์ด ์–ด๋–ป๊ฒŒ ์‹คํ–‰๋˜๊ณ  ์ž‘๋™ํ•˜๋Š”์ง€๋ฅผ ์ ๊ฒ€ํ•˜๊ธฐ ์œ„ํ•ด ์‚ฌ์šฉํ•œ๋‹ค.์—ฌ๊ธฐ์„œ sql์€ SELECT, INSERT

2020๋…„ 10์›” 27์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€

[SQL] Hint

Hint๋ž€ SQL ํŠœ๋‹์˜ ํ•ต์‹ฌ ๋ถ€๋ถ„์œผ๋กœ ์ผ์ข…์˜ ์ง€์‹œ ๊ตฌ๋ฌธ์ด๋‹ค.์˜ค๋ผํด Optimizer์—๊ฒŒ SQL๋ฌธ ์‹คํ–‰์„ ์œ„ํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ์Šค์บ๋‹ํ•˜๋Š” ๊ฒฝ๋กœ, ์กฐ์ธ ๋ฐฉ๋ฒ• ๋“ฑ์„ ์•Œ๋ ค์ฃผ๊ธฐ ์œ„ํ•ด SQL์‚ฌ์šฉ์ž๊ฐ€ SQL ๊ตฌ๋ฌธ์— ์ž‘์„ฑํ•˜๋Š” ๊ฒƒ์„ ๋œปํ•œ๋‹ค.์˜ค๋ผํด์ด ํ•ญ์ƒ ์ตœ์ ์˜ ์‹คํ–‰ ๊ฒฝ๋กœ๋ฅผ ๋งŒ๋“ค์–ด ๋‚ด๊ธฐ๋Š” ๋ถˆ

2020๋…„ 10์›” 27์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€

[SQL] ํŠœ๋‹

SQL ํŠœ๋‹์€ SQL๋ฌธ์„ ์ตœ์ ํ™”ํ•˜์—ฌ ๋น ๋ฅธ ์‹œ๊ฐ„๋‚ด์— ์›ํ•˜๋Š” ๊ฒฐ๊ณผ๊ฐ’์„ ์–ป๊ธฐ ์œ„ํ•œ ์ž‘์—…์ด๋‹ค.๋ถ€ํ•˜์˜ ๊ฐ์†Œ๋ณดํ†ต ์ผ๋ฐ˜์ ์œผ๋กœ ์ ‘๊ทผํ•˜๋Š” ํŠœ๋‹ ๋ฐฉ์‹์œผ๋กœ, ๋™์ผํ•œ ๋ถ€ํ•˜๋ฅผ ๋ณด๋‹ค ํšจ์œจ์ ์ธ ๋ฐฉ๋ฒ•์œผ๋กœ ์ˆ˜ํ–‰ํ•ด์•ผ ํ•œ๋‹ค.๋ถ€ํ•˜์˜ ์กฐ์ • ๋ถ€ํ•˜ ์ •๋„์— ๋”ฐ๋ผ ์—…๋ฌด๋ฅผ ์กฐ์ •ํ•˜๋Š” ์ ‘๊ทผ ๋ฐฉ๋ฒ•์œผ๋กœ, ์ผ๋ฐ˜ ์—…๋ฌด(OLT

2020๋…„ 10์›” 27์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€

[SQL] Index(์ธ๋ฑ์Šค)

Index๋Š” RDBMS์—์„œ ๊ฒ€์ƒ‰ ์†๋„๋ฅผ ๋†’์ด๊ธฐ ์œ„ํ•œ ๊ธฐ์ˆ ์ด๋‹ค.TABLE์˜ ์ปฌ๋Ÿผ์„ ์ƒ‰์ธํ™”(๋”ฐ๋กœ ํŒŒ์ผ๋กœ ์ €์žฅ)ํ•˜์—ฌ ๊ฒ€์ƒ‰์‹œ ํ•ด๋‹น TABLE์˜ ๋ ˆ์ฝ”๋“œ๋ฅผ Full Scan ํ•˜๋Š”๊ฒŒ ์•„๋‹ˆ๋ผ ์ƒ‰์ธํ™” ๋˜์–ด์žˆ๋Š” INDEX ํŒŒ์ผ์„ ๊ฒ€์ƒ‰ํ•˜์—ฌ ๊ฒ€์ƒ‰์†๋„๋ฅผ ๋น ๋ฅด๊ฒŒ ํ•œ๋‹ค.RDBMS์—์„œ ์‚ฌ์šฉํ•˜๋Š” I

2020๋…„ 10์›” 27์ผ
ยท
3๊ฐœ์˜ ๋Œ“๊ธ€

ANSI SQL์ด๋ž€?

DBMS(Oracle, My-SQL, DB2 ๋“ฑ๋“ฑ)๋“ค์—์„œ ๊ฐ๊ธฐ ๋‹ค๋ฅธ SQL๋ฅผ ์‚ฌ์šฉํ•˜๋ฏ€๋กœ, ๋ฏธ๊ตญ ํ‘œ์ค€ ํ˜‘ํšŒ(American National Standards Institute)์—์„œ ์ด๋ฅผ ํ‘œ์ค€ํ™”ํ•˜์—ฌ ํ‘œ์ค€ SQL๋ฌธ์„ ์ •๋ฆฝ ์‹œ์ผœ ๋†“์€ ๊ฒƒ์ด๋‹ค.ํ‘œ์ค€ SQL๋ฌธ์ด๊ธฐ ๋•Œ๋ฌธ์— DBMS์˜

2020๋…„ 10์›” 27์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€