Skip to Content
0
Former Member
Apr 25, 2009 at 03:21 PM

Query taking much time to execute

25 Views

The following query is taking more than 4hrs to execute.

select  l_extendedprice , count(l_extendedprice) from dbo.lineitem group by  l_extendedprice

Cardinality of table : 6001215 ( > 6 million)

Index on l_extendedprice is there

ReadAheadLobThreshold = 500

Database version 7.7.06.09

I need to optimize this query. Kindly suggest way out.

Thanks

Priyank