Subject Re: Why it's soo slow ? it's just a very simple select ...
Author nathanelrick
Thanks Svein,

> 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 this