speed of embedded sql statements

Hi,Can someone tell me how C can store a query execution plan so that the next time an embedded sql stmt is called the program will have the execution plan already stored ie won't have to go back and recalculate how the stmt is executed each time.Cheers