CREATE INDEX TRENDSRCH20.IDX_MEDIA_CRAWLDATE2 ON TRENDSRCH20.TB_ARTICLE_SEARCH_MEDIA (CRAWL_DATE ASC, ORA_HASH(“TITLE”) ASC )

SELECT /+INDEX(TB_ARTICLE_SEARCH_MEDIA IDX_MEDIA_CRAWLDATE2)/ SITE_ID FROM TRENDSRCH20.TB_ARTICLE_SEARCH_MEDIA WHERE SITE_SUB_TYPE = ‘네이버’ AND ORA_HASH(TITLE) = ora_hash(‘asdf’) AND CRAWL_DATE LIKE ‘20120430%’