Subject Re: [firebird-support] Firebird/Internet performance questions
Author David Johnson
Nice try ... it should return immediately with zero rows, but it doesn't.

This query performed a table space scan, requiring 23 minutes to complete compared to 0.076 seconds for "select min(OID) from mytable", even though there will definitely never be any results.

One-shot performance at startup is not a big deal to me. 23 minutes per table is a bit much to swallow though.

This looks like a query optimizer bug to me.

----- Original Message -----
From: Maciek BOROWKA
Sent: Thursday, January 15, 2004 5:24 AM
Subject: Rép. : Re: [firebird-support] Firebird/Internet performance questions

Perhaps a very naive question : why just don't use:

"select OID from MYTABLE where 1 = 2" to check the existence of a table?
This should be fast!


>>> d_johnson@... 15/01/04 15h05 >>>
I can determine table existence by "select the min(OID) from table". This will work quickly in all DBMS.

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]