Product management and Project management—they sound similar, and there’s (literally) only two letters that separate them. To top it off, these two concepts are commonly confused with each other, even by people experienced in product development! So it’s a classic case of tom-A-to tom-ah-to (tomato), right? Well, not so much. While they do sound similar, … Continue reading Difference between Product Management & Project Management.
Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables normally require less main memory while their contents are being actively processed during query execution. Any space reduction for table data also results in smaller … Continue reading Optimizing Database Structure – Optimize Data Size
Indexes are a very important concept, it makes your queries run fast and if you compare a SELECT query which uses an indexed column to one who doesn't you will see a big difference in performance. There can be two kinds of indexes in relational database Clustered and Nonclustered indexes. Clustered index determines physical sorting … Continue reading What is difference between Clustered and Nonclustered Indexes in (R) Databases?