Re: [sqlite] create indexed view

[Kees Nuyt]

On Tue, 26 May 2009 14:44:25 +0800, wying wy
 wrote:

>Hi
>
>May I know if we can create index on a View?

You can't create an index on a VIEW.
A VIEW can be seen as a stored SELECT statement. 

>Thanks in advance.
>wying
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] create indexed view

[wying wy]

Hi

May I know if we can create index on a View?

Thanks in advance.
wying
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] create indexed view

[wying wy]

Hi

May I know if we can create index on a View?

Thanks in advance.
wying
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users