Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community.
You should run tests for yourself on your own system and then come back to us if you're unsure of something. I didn't correctly interpret "I don't have significant tables".
Run EXPLAIN my_query for both queries for My SQL and compare the results. If my data increases, will it work well in the future? In any case, an EXPLAIN is useless without data, since the optimiser will behave differently depending on the amount of data in a given table - i.e.
with little data, it won't bother to use an index if the table is so small that a FTS (Full Table Scan) will zip through it more quickly, as mentioned in my first point.
You should test it on you system and compare the the execution data and plans.
But the database systems I know only optimize statement by statement and not pairs and groups of statements.
And for an optimal optimizer that possesses enough information about the data and optimizes statement by statement I would expect that he can create a better plan if the work is contained in one statement instead of distributed over two statements.For your statement it is possible that the optimizer for each of the three statements reads the whole table table2 and then scans the whole table table1 and changes the values according to the update clause.So the variant with two updates then will need to scans of table table1 and table table2 and only one scan of table table1 and table table2 for the second variant.Top Sites: Pantyhose Pics Nylon Paradise Nylon Feet Videos Strapon Screen Pantyhose Tales Matures and Pantyhose Secretary Pantyhose Pantyhose Screen Try Pantyhose Pantyhose Discounts Pantyhose Coeds Trans Pantyhose Pantyhose Face Pantyhose One Nylonfeet Line e Pantyhose Land Pantyhose Line Foot Fetish Porn Lingerie Queens Stockings Babes Wet Teen Panty Strapon Tales Foot Orgies Bi Trios Whips And Women Top Referrers: Foot Fetish 100 Mica's Pantyhose Highheels Sites Bella's Top Strumpfhosen Girls Sexjoy Top Stockings World Wives next-door Erotic Info Domfeet Top Clubtest top 100 BBW Top100 Red Apel Top TOP 50 Russtraum Poison Leg Redlight Magazin Magic Mature Upskirt flash BBW Pantyhose Elegant Anfisa Uniform 100 Fetish Heels Pantyhose Town X-total Tops Upskirt Zone Lotza Legs Flirty Blonde Erotictop 100 Smuttop 100 Hot Top Nylons Simply Stockings Aliessa Toplist Shiva Glamour Pantyhose Snatch ILPH Top Sites Lil Cindys Secrets Nylon Eroticx Erotik Rated Pantyhose Top Hips2Toes Feet Links World Feet Links Mrs Silk Top Pantyhose Toplist Amour de Lingerie The Porno Archive All Feet Links Footjobs 50 Feet 50 Toplist Mistress D-Strix Real Foot Sex Top 100 sites Miss Jones Links Babes on Top Golden Pantyhose Fet Land's Fetish Captive Culture Pantie View Sexy Rhonda Top Only Tease Sexoase Tops Amateurs Match UK Legs page Nylon Place Amateurs Toplist Pantyhose Movies Nylon Amateurs Nylon World Carol Cox Tops Dildo Lady Daily Dosage Wet Nylons Quality XXX Nylons & Pantyhoses Russian Feet Top Foot Fetish Estonian Toplist Certified Fetish Cyber Hose Fetish Top500 Emily Marilyn PH In Public Under her Feet Foot Fetish Zone Addicted to Legs Pantyhose Picpost Privataufnahmen Top Erotik Welt Top Anna's Toplist Dream Buffet Fetish Training Best Feet Links Pantyhose Review Hot Top Nylons Queen Of Heels Nylon and Feet Top Feet List Foot and Nylons Sexy Models UK Erins Leg Scene You get unlimited access to 17 top quality pantyhose sites (view the list of them) You get instant unlimited access to all the new pantyhose sites added to the system without additional charges(we add new sites once in a month or two). If you stayed our member for 4 months you’ll have unlimited access to all our sites for just .95/month.You get unlimited access to 18 top quality bonus sites (view the list of them).Currently in our database:• 1 000 000 pantyhose pictures• 10 000 pantyhose videos• 300000 bonus pictures and 1000 bonus videos With updates you get:• 210 new pantyhose sets (approximately 22000 pictures) and 60 new pantyhose videos every month! Visit Love Nylons, brand new site dedicated to the love of beautiful women wearing sexy nylons and stockings.