Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
WHY is LogicalFile but not index?
After switched a data file from using logical file to index, the sql process got tremendously slowed down ( the file has millions records). Why and how can I fix it? -
WHY In Clause Faster than EXISTS clause?
I used to use the exists clause in my embedded sql statement and it was always working fine. But my process is suddenly chocked and I found out the problem was exists clause, if I changed the exists clause to in clause, the process would be resumed. Any idea? Please help and thanks in advance -
WHY In Clause Fater than EXISTS clause?
I used to use the exists clause in my embedded sql statement and it was always working fine. But my process is suddenly chocked and I found out the problem was exists clause, if I changed the exists clause to in clause, the process would be resumed. Any idea? Please help and thanks in advance
