하늘을향해

/*+ LEADING(TT SS) USE_NL(SS)*/

LEADING 은 테이블 접근순서, USE_NL는 Nested Loop사용하도록 정의

Nested Loop Join, Hash Join, Sort Merge Join 3가지 가있음

Nested Loop Join : 온라인성(OLTP) 쿼리에 많이 사용

Hash Join : 배치성(Batch) 쿼리에 많이 사용

Sort Merge Join : 사용안함

참조

https://exmemory.tistory.com/44

ibatis X

  ApplicationContextProvider  
  

@Component public class ApplicationContextProvider implements ApplicationContextAware { private static ApplicationContext ctx; @Override public void setApplicationContext(ApplicationContext ctx) throws BeansException { this.ctx = ctx; } public static ApplicationContext getApplicationContext() { return ctx; } }

  사용법  
  

ApplicationContext ctx = ApplicationContextProvider.getApplicationContext(); Test test = (Test)ctx.getBean(Test.class);