Fetch Only Required Columns From a Database to Improve Performance

Fetch Only Required Columns From a Database to Improve Performance

The call ‘select * from ‘ becomes costly when tables have a lot of fields. Because every data field would be required to be sent across the network (or processed) and buffered, reducing the number of data fields fetched directly enhances query and application performance. Therefore, you should fetch only required columns from your database and avoid queries like ‘select * from ‘. The queries that check for the existence of a record and use ‘select * from ‘ should be modified by putting * into single quotes. For example, it is better to fire a query like

      select '*' from  where  = 

in place of

      select * from  where  = 

to check for the existence of a record.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular