Hi, we have a View which joins a few tables.
when we run a select from this view, the query takes a lot of time to run, following runs of the same SQL runs pretty fast. so select * from myview where id=1 where ID is the primary key of the driving table. the above selects takes about 55 seconds to run. now the same select run again takes less than 200 ms so what gives? is there a way to avoid this, any work arounds? any setup/parameters that we missed. Thanks Pramod ===== __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
