(4) Database Design We have developed a Libary of free Kick-Start Database designs. These take the form of Data Models, created in a Modelling Tool called DataArchitect by PowerDesigner/Sybase. If you have a specific requirement that you can't find, then
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run faster
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run fast