Well it depends on the quality of fuel and your driving style. Engine power is a function of the fuel, as well as the engine design, and is related to octane rating of the fuel. Power is limited by the maximum amount of fuel-air mixture that can be forced into the combustion chamber.
Many high-performance engines are designed to operate with a high maximum compression, and thus demand high-octane fuel. A common misconception is that power output or fuel mileage can be improved by burning higher octane fuel than a particular engine was designed for. The power output of an engine depends in part on the energy density of its fuel, but similar fuels with different octane ratings have similar density. Since switching to a higher octane fuel does not add any more hydrocarbon content or oxygen, the engine cannot produce more power. However, burning fuel with a lower octane rating than required by the engine often reduces power output and efficiency one way or another. If the engine begins to detonate, that reduces power and efficiency for the reasons stated above.
So for high compression engines use high octane fuel whereas for low compression engines you can use normal super fuel. One thing more to mention is that we don't have good quality of fuel in Pakistan. As the octane level of super is 87 when the required octane level of fuel for Honda and Toyota engines is 91. so using high octane fuel is highly recommended in order to achieve the desired/designed efficiency out of the engine. In case of cars like XLi or suzuki, you can use super but for civic & corolla Altis, high octane is recommended.
I hope its quite clear now