Ok, I am officially loosing my mind!!!
We are running QuickBooks 2006 Pro. Our database file size is 94-MB.  
Qodbc Version: 6.00.00.155  

When I run Any of the lines below IT DOES NOT WORK:
SELECT top 10 * FROM ReceivePaymentLine  Unoptimized        (Nothing happens after 30-seconds)
SELECT * FROM ReceivePaymentLine  ReceivePaymentLine  Unoptimized
SELECT TxnID FROM ReceivePaymentLine   (without Unoptimized option)

But when I run (Select TXNID From  ReceivePaymentLine  Unoptimized) I am able to pull all the TXNID's for all the 5,600 records.

Am I doing something wrong-?
Would you like me to post the Detail Tracing Log-?

Thank you
Harry

Note:
 And this happens with other large Tables Like InvoiceLine, DepositLine... Etc.

I've done some testing and I can't get the InvoiceLine or DepositLine record counts not to match, but using ReceivePaymentLine I can reproduce the problem:

Count
80     Select * From ReceivePaymentLine  Unoptimized
80     Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName From  ReceivePaymentLine
80     Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName From  ReceivePaymentLine verified
80     Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName From  ReceivePaymentLine 
93     Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName 
         From  ReceivePaymentLine  Unoptimized

This Intuit qbXML SDK bug causes a SELECT * only to show the incorrect number of ReceivePaymentLine lines where there's more than one line:

when there's actually four payment lines for Nguyen while other lines are missing altogether:

And before anyone goes crazy, yes, there's four lines for Nguyen in QuickBooks:

For now, try using the columns you need in your selects and not a * for all Columns, with the UNOPTIMIZED tag.

Well, somehow I got the Unoptimized feature to work on the query line.  Now when I use the Where clause statement it takes 25min and I am not exaggerating.  And I can not use the NoSync feature because it will not optimize the ReceivePaymentLine table.

This takes 25-min:
        Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName 
         From  ReceivePaymentLine  Unoptimized Where AppliedToTxnTxnID='2DB-1019496685'

Is there any way we can speed up this query-? 

Thank you
Harry

The Intuit qbXML SDK bug that causes a SELECT * only to show the incorrect number of ReceivePaymentLine lines (used by the Optimizer), while other lines are missing altogether will be fixed by Intuit in the R7 update for QuickBooks 2006 and Enterprise 6.0 which isn't officially released yet at: http://www.quickbooks.com/support/index/ndxw_15_update.html (Intuit currently show only up to R6 as at May 25, 2006).

You can now download v6.00.00.176 (see: How can I get the latest version of QODBC? ) and do a:

sp_optimizefullsync ReceivePaymentLine

to resync your optimized ReceivedPaymentLine table. Once that's done:

Select * From ReceivePaymentLine

Select * From ReceivePaymentLine Unoptimized

Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName
From ReceivePaymentLine

Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName
From ReceivePaymentLine Unoptimized

should all match.