CODEWITHSUNDEEP
sqloracle-databasebi-publisher
Imran Hemani
Imran Hemani

Reputation: 629

Data Set in BI Publisher

While creating a dataset in BI Publisher, which one is more optimized?

Select * from <table_name>  
OR
select column1, column2 from table_name?

Is there any difference between mentioning specific columns and doing a select all statement? provided that all the columns are being used in the report.

Upvotes: 0

Views: 256

Answers (2)

cdabel
cdabel

Reputation: 501

I agree with user FallAndLearn. But regardless of whether .rtf file is being used, naming the columns explicitly is always recommended from an optimization and SQL tuning perspective.

Upvotes: 1

FallAndLearn
FallAndLearn

Reputation: 4135

select column1, column2 from table_name

Above should be used, as the column names would be mapped to the names used in your .rtf file.

We use a .xdo or .xdm file for mapping of DB columns to the variables used in .rtf file.

Upvotes: 1

Related Questions