Do I need to run Optimize Table after introducing new indexes?

Query statement on how to transfer data from one table to another

Please anyone help me with resources

pm me

I have done message

Insert into tbl_year2
select * from tbl_year1

Hello guys, I need some help from those who are knowledgeable in relational databases

I am currently developing filtering on one of the projects, and this filtering should, if possible, be like that of Amazon
many dynamic filters (if the whole table is denormalized and everything is in one table except 1 join to another table 🙂 )

My questions:
How stupid is Mysql 5.6 and you need to adjust the conditions WHERE a=1 AND b=1 or for example WHERE b=1 AND a=1 (it will do it under the hood?, but if there are more than 10 of these conditions?)
What is the maximum number of indexes we can add?
How to build these indexes correctly? Check me:
1 – the most popular field
2 – sorting by these fields (date/price/name)
Can everything stop now? or:
3 – the next most popular lattitude field
4 – longitude
5 …
6…
16 …

and so it turns out that there are 3 sorts
means 3 composite indexes on (4 fields) am I right?
this way we will speed up for example most requests

and to speed up, for example, narrow-profile queries, should I create new indexes and set all these conditions up to the limit of 16 columns in the index? Or to add here in the previous indexes at once? (which I doubt because there is a left prefix rule, apparently which says the order in the WHERE clause is important)
how will it work faster?

Can I build indexes without the first four popular fields?

Also what to do if there is filtering (example of WHERE of a real query)
((ams.seller_type = ‘PRIVATE’ AND ams.year >= YEAR(CURRENT_DATE()) – 14 AND ams.inspection_place_latitude BETWEEN 43.68760853 AND 46.38557461 AND ams.inspection_place_longitude BETWEEN 37.16931132 AND 40.98654368 AND ams.km_distance0 < .is_pledged, 0) = 0 AND ams.published = 1)) ORDER BY ams.sale_started_at DESC LIMIT 50 OFFSET 900

COALESCE falls under the index ?

Do I need to run Optimize Table after introducing new indexes? after all, the optimizitor will already walk along well-trodden paths? (or better use FORCE INDEX construct in queries)

And after we deal with the above
How to build indexes on OR ? (multi filtering)
WHERE(
((ams.seller_type = ‘PRIVATE’ AND ams.year >= YEAR(CURRENT_DATE()) – 14 AND ams.inspection_place_latitude BETWEEN 43.68760853 AND 46.38557461 AND ams.inspection_place_longitude BETWEEN 37.16931132 AND 40.98654368 AND ams.km_distance0 < .is_pledged, 0) = 0 AND ams.published = 1))
) OR (
((ams.seller_type = ‘NO PRIVATE’ AND ams.year >= YEAR(CURRENT_DATE()) – 14 AND ams.inspection_place_latitude BETWEEN 43.68760853 AND 46.38557461 AND ams.inspection_place_longitude BETWEEN 37.16931132 AND 40.98654368 AND ams.inspection_place_longitude BETWEEN 37.16931132 AND 40.98654368 AND ams.km0 0 ams.is_pledged, 0) = 0 AND ams.published = 1))
)

Please guide how to find particular 1 student name corresponding teacher code.

Use CONCAT function over name and teachercode

How to get @got_error value in node js mysql query

Can anyone help

Hi can we create user in mysql for a specific range of IPs if yes then how we can create it

Any help will be appreciated

Use IP address instead of localhost

IP address in dynamic not static

Can we create a user for specific IP range xx.xx.xx.01/xx.xx.xx.15

Like above mentioned

172.168.%

Okay use percentage in the last digits right

Wildcard

Can any one explain why I can’t enter words in Varchar

Does anyone have this course

Every varchar/text has to be inserted with single quote
Example
Insert into tablename
values
(‘soumith’,’reddy’)

Thanks for the reply

How to solve Max_prepared_stat_count error without increasing its variable value and without restarting the service

How to do database masking on MySQL suggest me any article….?

Can anyone help me with the parsing of the JSON file to SQL, or if you have some materials related to it, even that will be very helpful.

Hi
How can I get the information of a column as a list in Python?

asking in the python group

Pls send the answer

A