General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>select anything from a inner join b on a.field=b.field and a.field>0 where a.field>0 into anything
>>
>>Of course, it is not a problem when the number of filtered records are relativly little.
>>
>>But a two big (?) 10M, inner joined table produced me an INSUFFICIENT DISK SPACE error message. (It produced a +150M intermediate cursor and 25 sec run time)
>
>Bela, you could try doing this as two selects: do the first one to filter table a, and then join the filtered tables.
Dear Garrett,
thanks for quick answer. As I wrote, putting where criteria into join condition does the job:
select anything from a inner join b on a.field=b.field and a.field>0 where a.field>0 into anything
I only wanted to know, if my thinking about SQL select intermediate (hidden) cursor is true or not.
bb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only