General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi all
I have a table XXX with 25 fields (ctype, nNum, ... filed25) and aprox 100.000 records and following code:
scan for ctype=cvar1 and nnum=nvar2
...
endscan
Recently this scan became very slow. I've indexed the table in cType and nNum to optimyze speed but it does no work...
Any ideas would be great.
Thank's in advance,
NPedro
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