|
|
Posted by InfoSponge3000 on 09/11/06 14:31
Sounds like you need a proper index for your query. I have tables with
over 90 million rows that give subsecond query results because the
indexes are optimized for the queries.
bozzzza@lycos.co.uk wrote:
> Erland Sommarskog wrote:
> > bozzzza@lycos.co.uk (bozzzza@lycos.co.uk) writes:
>
> > Yes. That would mean that SQL Server would first get any 10 rows, and then
> > sort the 10 rows on Code. That does not appear as a very useful operation
> > to me....
> >
>
> Thanks,
>
> We have a massive table, that is taking 2 minutes to return the data,
> and causing Sql Server Timeouts. I am looking into ways I can speed it
> up.
Navigation:
[Reply to this message]
|