General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Steve;
Are you on a network? How many records in the file? Do you have seperate CDX tags for custID and poNum? Your first Select statement should run quickly with the two required index tags.
select * from pastinvoices as pinv where pinv.custID = "149" and ;
pinv.poNum = "143619" into cursor cp
Have you tried sys(3054) to see Rushmore optimization?
Questions, questions always questions.
Tom
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only