Hi,
I have following schema: TimeStamp MACAddress Data Transfer Data Rate LocationID PKEY is (TimeStamp, MACAddress). That means partitioning is on TimeStamp, and data is ordered by MACAddress, and stored together physically (let me know if my understanding is wrong). I have 1000 timestamps, and for each timestamp, I have 500K different MACAddress. When I run the following query, I get RPC Timeout exceptions: Select * from db_table where Timestamp='...' >From my understanding, this should give all the rows with just one disk seek, as all the records for a particular timeStamp. This should be very quick, however, clearly, that doesn't seem to be the case. Is there something I am missing here? Your help would be greatly appreciated. Thanks PP
