When running exploratory queries, many SQL developers use SELECT * (read as “select all”) as a shorthand to query all available data from a table. Make sure the requirements are as specific as possible and confirm the requirements with all stakeholders before running the query.Ģ. Write very specific requirements and confirm them with stakeholders. The performance of the production database is too critical to have unclear or ambiguous requirements. ![]() Ask great questions. Follow the 5 W’s: Who? What? Where? When? Why?.This will focus the query on the tables with the correct level of detail. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |