| Subject | Re: [firebird-support] Re: Why it's soo slow ? it's jus t a very simple select ... |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2012-03-07T10:18:06Z |
On Wed, 07 Mar 2012 09:23:11 -0000, "nathanelrick" <nathanelrick@...>
wrote:
What is the plan for the query?
wrote:
> Thanks Svein,this
>
>> Is your query,
>>
>> select IDObj From DESCRIPTION where ID='ID_HAS_NEVER_EXISTED', or
>> select IDObj From DESCRIPTION where
>> ID='ID_THAT_IS_RECENTLY_DELETED_UPDATED_OR_ADDED'?
>
> First case ID='ID_HAS_NEVER_EXISTED', so unfortunatly it's not this ..
> also i do the test on a fresh backup/restored database, even a newly
> created and filled table to be sure about versioning ... not look like
What is the plan for the query?