Indexes [message #4100] |
Fri, 08 November 2002 09:35 |
Dee
Messages: 11 Registered: September 1999
|
Junior Member |
|
|
How do I create an index on the DAY and TIME fields in a COURSE_SECTION table with DAY as a primary search value and TIME as a secondary search value.
COURSE_TABLE description has the following columns
c_sec-id, course_id, term_id, sec_num,f_id,day,time,loc_id and max_enrl
|
|
|
Re: Indexes [message #4101 is a reply to message #4100] |
Fri, 08 November 2002 11:33 |
ctg
Messages: 146 Registered: July 2002
|
Senior Member |
|
|
create index course_section_day_time_idx
on course_section(day,time)
tablespace tsname
...
|
|
|