Index on a View?

Index on a View?

Post by Frank D. Grec » Thu, 10 Jul 2003 11:13:54



Anyone know if you can put an index on a view (11.9.X)?

I tried searching the (really slow) Sybase website but
wasn't having much luck.  Google wasn't that helpful either.

Thanks,

Frank
+=========================================+
| Crossroads Technologies Inc.            |
| Enterprise Java Engineering             |
|   Web: www.CrossroadsTech dot com       |

+=========================================+

 
 
 

Index on a View?

Post by Rob Verschoo » Thu, 10 Jul 2003 15:58:00




> Anyone know if you can put an index on a view (11.9.X)?

> I tried searching the (really slow) Sybase website but
> wasn't having much luck.  Google wasn't that helpful either.

> Thanks,

> Frank
> +=========================================+
> | Crossroads Technologies Inc.            |
> | Enterprise Java Engineering             |
> |   Web: www.CrossroadsTech dot com       |

> +=========================================+

No, you can't; at least not in the current versions of ASE.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

New book(coming soon): 'Tips, Tricks & Recipes for Sybase ASE'
For details, see http://www.sypron.nl/ttr


http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

 
 
 

Index on a View?

Post by species847 » Thu, 10 Jul 2003 16:15:01


No you can't.

You can create an index on the underlying base table.

--
Joop

"Soylent green is people"

Senior Consultant Sybase Professional Services
http://thedominion.cc/



> Anyone know if you can put an index on a view (11.9.X)?

> I tried searching the (really slow) Sybase website but
> wasn't having much luck.  Google wasn't that helpful either.

> Thanks,

> Frank
> +=========================================+
> | Crossroads Technologies Inc.            |
> | Enterprise Java Engineering             |
> |   Web: www.CrossroadsTech dot com       |

> +=========================================+

 
 
 

Index on a View?

Post by Frank D. Grec » Fri, 11 Jul 2003 12:03:19





>> Anyone know if you can put an index on a view (11.9.X)?

>> I tried searching the (really slow) Sybase website but
>> wasn't having much luck.  Google wasn't that helpful either.
>No, you can't; at least not in the current versions of ASE.

Thanks Rob.  I recall reading MS SQLServer allows indices on views.

Frank
+=========================================+
| Crossroads Technologies Inc.            |
| Enterprise Java Engineering             |
|   Web: www.CrossroadsTech dot com       |

+=========================================+