[合集] 问一个Oralce index的问题# Database - 数据库
E*i
1 楼
☆─────────────────────────────────────☆
yiyayiyayo (Mera naam Itiaan hai) 于 (Fri May 18 11:34:30 2007) 提到:
比如说:
select last_name from employees where upper(last_name) like 'JO%';
有没有创建一个index在last_name上,我们肉眼根本看不出区别的吧,是不是?
☆─────────────────────────────────────☆
tailang (西瓜太郎) 于 (Fri May 18 13:46:28 2007) 提到:
select * from all_indexes where table_name = EMPLOYEES
☆─────────────────────────────────────☆
yiyayiyayo (Mera naam Itiaan hai) 于 (Fri May 18 16:07:31 2007) 提到:
I don't know
yiyayiyayo (Mera naam Itiaan hai) 于 (Fri May 18 11:34:30 2007) 提到:
比如说:
select last_name from employees where upper(last_name) like 'JO%';
有没有创建一个index在last_name上,我们肉眼根本看不出区别的吧,是不是?
☆─────────────────────────────────────☆
tailang (西瓜太郎) 于 (Fri May 18 13:46:28 2007) 提到:
select * from all_indexes where table_name = EMPLOYEES
☆─────────────────────────────────────☆
yiyayiyayo (Mera naam Itiaan hai) 于 (Fri May 18 16:07:31 2007) 提到:
I don't know