Re: Informix 7.3 temp table Problem
Bundesarchiv wrote:
>
> Hi,
>
> we had a response time Problem:
>
> create temp table browse2(row_id integer);>
> insert into browse2
> select rowid from elgsgt where bstkey = 238 and archivnr = 16054;> (selects 1 record, elgsgt = 2500000 Records)
>
> select * from elgsgt where rowid in
> (select row_id from browse2);> == needs ca 5 mins to answer, ==> tablescan
>
> (in Informix 5.05 no Problem)
> Online 7.3 UC2 on a HP 9000 D 330 UX 10.
>
> Ernst-Ludwig Brust
What does "set explain on" say??
John Carlson
Informix DBA
WHSmith USA