Well, I don’t know what the hint does there... it's not there in my connexion script. So, I removed the "WITH(index=PK_RECHERCHE_CONTENU)" and here's the plan:

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1"...

Oups, sorry!

Is this the right plan?

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.2500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

<Batch>

<Statements>

...

Hi! Thanks for answering!

As Ninja's_RGR'us said, it couldn't be a memory usage problem since it takes 40 seconds the first time, and less than a second the next time.

Here's the...