Hi Chris, at 03:00 , when you mention that indexing should only be done on the tables which are not frequently updated or edited. Are you referring to the columns or rows or both? Also, regarding using simple operators only: would you suggest using an index for a "less than" operator, say in the "date" or "amount" column?
HI there! I apologize, I'm not quite sure what you're going for here. The rules that apply to when you should index aren't really things that would be managed automatically.
@@nocodebackend I was being interviewed for a role to use Xano as part of a team to build an app, and my lack of understanding of performing database normalization in Xano was the reason that I was not considered for the role. As I researched that concept, I came across tools that would aid in database normalization ie taking in database schemas analyzing and providing new database tables that would adhere to the 5 rules of database normalization. My question was could Xano implement the database normalization techniques to ensure that databases we construct in Xano were well performant since Xano's databases are built using postgresql. Let me know if I could share more with you guys as it would be my pleasure. Keep up the great work, with the new hires only way up is up.
Hi Chris ! when new records are added to a database after creating an index, this record is automatically added to the index? or do you have to manually refresh the index?
Complete game changer, thanks so much Chris! I think my background tasks got like x1000 faster... couldn't believe it
Love that! So glad it helped.
Hi Chris,
at 03:00 , when you mention that indexing should only be done on the tables which are not frequently updated or edited. Are you referring to the columns or rows or both?
Also, regarding using simple operators only: would you suggest using an index for a "less than" operator, say in the "date" or "amount" column?
Hi @Chris, how about automatically performing normalization of database to adhere to the 5 rules?
HI there! I apologize, I'm not quite sure what you're going for here. The rules that apply to when you should index aren't really things that would be managed automatically.
@@nocodebackend I was being interviewed for a role to use Xano as part of a team to build an app, and my lack of understanding of performing database normalization in Xano was the reason that I was not considered for the role. As I researched that concept, I came across tools that would aid in database normalization ie taking in database schemas analyzing and providing new database tables that would adhere to the 5 rules of database normalization. My question was could Xano implement the database normalization techniques to ensure that databases we construct in Xano were well performant since Xano's databases are built using postgresql. Let me know if I could share more with you guys as it would be my pleasure. Keep up the great work, with the new hires only way up is up.
Hi Chris !
when new records are added to a database after creating an index, this record is automatically added to the index? or do you have to manually refresh the index?
The index is automatically maintained; no intervention required on your side.