search for: openread

...library(sqldf) sqldf("explain query plan select * from BOD") ## id parent notused detail ## 1 2 0 0 SCAN BOD sqldf("explain select * from BOD") ## addr opcode p1 p2 p3 p4 p5 comment ## 1 0 Init 0 10 0 <NA> 0 NA ## 2 1 OpenRead 0 2 0 2 0 NA ## 3 2 Rewind 0 9 0 <NA> 0 NA ## 4 3 Column 0 0 1 <NA> 0 NA ## 5 4 RealAffinity 1 0 0 <NA> 0 NA ## 6 5 Column 0 1 2 <NA> 0 NA ## 7 6 RealAffinity 2 0 0 <NA> 0 NA...

dear Members, I have recently started studying SQL and MySQL. My question is, what exactly is SQL used for? That is, whatever can be done by SQL, like subsetting and filtering of data sets, can also be done by R. What's, then, the advantage of SQL? It is OK if you tag this question as offtopic, but I could'nt find any info on the web. Can you please refer me to