cima
New User
Joined: 22 Mar 2006 Posts: 8
|
|
|
|
Hi all,
I'm wondering if timestamp is useful to be included in the index to avoid internal sort. Or is it generally not recommended?
sample table:
create table tab1
(col1 char(1) not null
,col2 char(1) not null
,col3 char(1) not null
,col4 char(1) not null
,col5 char(1) not null
,col6 char(1) not null
,col7 char(1) not null
,col8 char(1) not null
,col9 char(1) not null
,timestamp not null)
in prototyp.tablespace
example sql:
exec sql
select * from tab1
where col1 = 'A'
order by timestamp;
thanks,
cima |
|