Do you know What Perfect means? We, Koreans, easily use a word, perfect, and it's not actually perfect for everyone's request. 카테고리 없음 2007.01.12
Do you know What Perfect means? We, Koreans, easily use a word, perfect, and it's not actually perfect for everyone's request. 일상다반사/Talking 2007.01.12
Function-Based Indexes The Oracle server uses the index only when that particular function is used in a query. If the function is not used in a query and there is no specific index, the Oracle server will full scan. QUERY_REWRITE_ENABLE initialization parameter must be set to TRUE for a function-based index to be used. CREATE INDEX upper_dept_name_idx ON dept2(UPPER(department_name)); Oracle 2007.01.10
Function-Based Indexes The Oracle server uses the index only when that particular function is used in a query. If the function is not used in a query and there is no specific index, the Oracle server will full scan. QUERY_REWRITE_ENABLE initialization parameter must be set to TRUE for a function-based index to be used. CREATE INDEX upper_dept_name_idx ON dept2(UPPER(department_name)); By Office 2007 Oracle 2007.01.10